Isn't That how your supposed to do it using Sprocs is more time consuming but it...

gdulli · on June 18, 2015

There's no way you're "supposed to" do it. There are tradeoffs and you pick the approach you like most given those tradeoffs.

spacecowboy_lon · on June 19, 2015

Not sure id agree 100% with you for standard LOB CRUD applications the use of Sprocs is best practice.

Obviously if your just writing a tool that will be used 2 or 3 times that - you can make trade offs - but you should never use $sql = "SELECT * FROM tblBobbins"