Need help finding syntax error for MySQL

Asked May 16 '17 at 15:30

Active May 16 '17 at 15:40

Viewed 38 times

I keep receiving a syntax error for the following code line using MYSQL 5.1

if(isset($_REQUEST['filter']) && (strlen($_REQUEST['filter']) > 0) && ($_REQUEST['filter'] == 'all')) {
$getqry = "SELECT * FROM ".$dbtbrestaurants."";
}

Can anyone help me understand why I an receiving a syntax error for the above code and help me fix this.

Thank you

edited May 16 '17 at 15:40

asked May 16 '17 at 15:30

tony

1

What's the value of `$dbtbrestaurants`? – Jonnix May 16 '17 at 15:31
For a change I have to wonder why something got up-votes... :P – Jonnix May 16 '17 at 15:32
whats the use of `.""` at the last ? – lu5er May 16 '17 at 15:32
@JonStirling $dbtbrestaurants points to which table to look for data in related to restaurants. – tony May 16 '17 at 15:33
@tony What's the value of `$dbtbrestaurants`? – Jonnix May 16 '17 at 15:34
@tony Edit your question and add the value of: `var_dump($dbtbrestaurants);`. If you receive a mysql error also add that to your question. – Rizier123 May 16 '17 at 15:36
1

@lU5er "" completes the line. Initially there was an ORDER by there example ("SELECT * FROM ".$dbtbrestaurants." ORDER by id") – tony May 16 '17 at 15:36

Need help finding syntax error for MySQL

0 Answers0