MYSQL variable and escape string issue

Question

I'm trying to get this to work but I have no idea what's wrong with it.

$sql = "SELECT * FROM $datatable ORDER BY ID ASC LIMIT $start_from,
$results_per_page WHERE STATE='$category'" ;

The following one works and just shows the entire table. But I'm running into issues when I try to use WHERE STATE=Variable

$sql = "SELECT * FROM ".$datatable." ORDER BY ID ASC LIMIT $start_from, ".$results_per_page ;

theDima · Accepted Answer · 2017-03-22 16:25:50Z

1

You should write "ORDER BY" after the "WHERE" part. In your case it should be something like:

$sql = "SELECT * FROM $datatable WHERE STATE='$category' ORDER BY ID ASC LIMIT $start_from, $results_per_page" ;

answered Mar 22, 2017 at 16:25

theDima

7561 gold badge4 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1