MySQL Error

[bxflow]

#1064 - 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 '$x = mysql_query('SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1')' at line 1

bxflow Reviewed by bxflow on 26th Jun 2010. MySQL Error Im installed some script but i get this errors Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/XXXXXXX/public_html/index.php on line 99 line 99: while ($y=mysql_fetch_assoc($x)) Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/XXXXXXX/public_html/index.php on line 80 Rating: 5

[Mr Happy]

#1064 - 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 '$x = mysql_query('SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1')' at line 1

The only part you run in PHPmyadmin is

SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1

Anyway a bit offtopic but you should escape this and make it safe:

$like=$_POST["like"]; 

$like=mysql_real_escape_string($_POST["like"]); 

It will help prevent hacking and make your script safer.

More info here http://php.net/manual/en/function.my...ape-string.php

[bxflow]

The only part you run in PHPmyadmin is

SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1

Anyway a bit offtopic but you should escape this and make it safe:

$like=$_POST["like"]; 

$like=mysql_real_escape_string($_POST["like"]); 

It will help prevent hacking and make your script safer.

More info here http://php.net/manual/en/function.my...ape-string.php

thanx,


#1064 - 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 ''SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1' at line 1

[Mr Happy]

thanx,


#1064 - 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 ''SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1' at line 1

Try it again. You have an extra ' before the SELECT that shouldn't be there. Probably an error copying and pasting it.

PHPmyadmin checked for

'SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1

when it should be

SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1