mysql query error

Question

This is very simple but I keep getting a error for some reason:

MySQL view all error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''LIMIT 0,6'' at line 1

$max = 'LIMIT 0,6';

$data = mysql_query("SELECT * FROM `gallery` '$max'") or die( 'MySQL view all error: ' . mysql_error());

Answer 1

Do not quote the $max part.

Answer 2

Your query would become; SELECT * FROM gallery 'LIMIT 0,6';

which is not a true sql query;

try this:

$data = mysql_query("SELECT * FROM gallery {$max}") or die( 'MySQL view all error: ' . mysql_error());