MySQL Error

[natsu90]

i'm not real smart but try to help. also got this error once ago and solved. try changing into another name instead 'like' on your db. it's a reserved word. don't forget to change the name on php too. regard.

edit: i mean 'like' on column name of 'fblike' table, not on the db name

[bxflow]

lol your Query is wrong

$x = mysql_query('SELECT * FROM fblike ORDER BY id DESC LIMIT  0,1');

//Try dump out whit it is, using the code below
var_dump($x); //See if it comes back as a resource. 

if it returns (bool) false then the table fblike does not exists or the column id does not exist.

i tried it and it returned (bool) false

the database is there so is the table fblike
so idk wtfak is wrong

[Whoo]

Before you do something with the $x, and after the query, add this:

if(mysql_num_rows($x)){
  //Do your stuff
}else{
  //No results found
} 

[Lock Down]

That won't help except to say there is an error/empty just like the var_dump did.

replace

var_dump($x);

with

if (mysql_error()){echo "<br>Error on fblike table: ".mysql_error();}

[litewarez]

No dont do all that, whoo your wrong, you cant count the rows if mysql_result returns false;

Copy the query and run it within phpMyAdmin and send us the error. IF there is no error, make sure your selecting the correct db in your config.

[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

[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

[litewarez]

yea what he said.

[Whoo]

No dont do all that, whoo your wrong, you cant count the rows if mysql_result returns false;

Copy the query and run it within phpMyAdmin and send us the error. IF there is no error, make sure your selecting the correct db in your config.

Using the code I have given it won't do anything if the result is 0 , but yeah it won't help fixing a error in the query.

[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