MySQL Selection

The_Silent

Okay, I'm working on a news script and am having trouble retrieving the comments. The comment table features a column "post" which contains the id of the post it is associated with, as well as unique "id" column for each comment. I have two comments in place right now for testing, both with the same "post" value. Here's my current query:

         $commentquery = mysql_query ('SELECT * FROM ' . $tableprefix . 'chronicle_comments WHERE post="' . $postid . '" ORDER BY id"')
                                     or die ('Could not select comment info.');

It gives me the die message, and I think it's due to the fact that WHERE is supposed to specify only a single row in MySQL. I'm wondering how to select multiple rows based on the content of a field...

gardnc

Try this:

$commentquery = mysql_query ("SELECT * FROM " . $tableprefix . "chronicle_comments WHERE post='" . $postid . "' ORDER BY id")

crazychris

I recon you have a error in your query. So, instead of using die() print the mysql_error() so see where it's all going wrong. You could even replace the "or die ('Could not select comment info.');" with "or die (mysql_error());"

The_Silent

Well, I did that and it's now giving me this:

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

Also, if it makes a difference I'm using PHP 4.4.1 and MySQL 4.1.14...

Weedpacket

Well, the error message is saying that MySQL has a problem with a " somewhere. Have a look at the query you are sending it, and see where the "s are and confirm that they are where they are supposed to be.

The_Silent

Thanks, that fixed the error, but it still didn't do what I wanted so I had to restructure it. It's all working now though. Thanks again...