Query problem with LIMIT.

[kernelgpf]

The 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 1' at line 1"

 

The code:

mysql_query("SELECT pet_id from pets ORDER BY pet_id DESC() LIMIT 1")or die(mysql_error());

[mkebkr04]

$query = "SELECT pet_id from pets ORDER BY pet_id DESC() LIMIT 1")or die(mysql_error())";

 

$result = mysql_query($query);

[kernelgpf]

... I omitted surrounding code to get to the base of the problem.

[mkebkr04]

So you found your answer?

[kernelgpf]

No. I meant I know how to do basic MySQL and your answer is not the solution.

 

My entire code is this:

$IDquery=mysql_query("SELECT pet_id from pets ORDER BY pet_id DESC() LIMIT 1")or die(mysql_error());
$IDrow=mysql_fetch_array($IDquery);
$babyID2=$IDrow[pet_id];

[teng84]

not sure if putting the " () " on your DESC clause is right DESC() 

 

should be

"SELECT pet_id from pets ORDER BY pet_id DESC LIMIT 1"