SQL Error

Inevitable

Whenever I try to run this query:

SELECT post_id, post_owner, post_create_time FROM forum_posts WHERE topic_id = '$topic_id' ORDER BY post_id DESC LIMIT 1

I get this 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 ') FROM forum_posts WHERE topic_id = 3' at line 1

bogu

This is a question for database section of this forum...

The problem might be $topic_id, u need to check if is not empty ...

peterg012

Are you not missing the red....

SELECT post_id, post_owner, post_create_time, topic_id FROM forum_posts

Installer

You're apparently not showing us the actual query string. If you look at the error message you'll notice there is a single quote missing.

BTW, the missing red isn't necessary for a valid query.

Inevitable

Installer wrote:
You're apparently not showing us the actual query string. If you look at the error message you'll notice there is a single quote missing.

Okay, here is the query string. I couldn't find any missing quotes missing, though.

$get_last_post_sticky = "SELECT post_owner, post_create_time FROM forum_posts WHERE topic_id = '$topic_id' ORDER BY post_id DESC LIMIT 1";

$get_last_post_res_sticky = mysql_query($get_last_post) or die(mysql_error());

bogu

Installer, want to say that, that query is not the one that trigger the error, so u should look for another query ...