A little trouble here!

[monkeybidz]

I am having trouble with this. I am trying to get data for a comment by id. I get data back for only certian id numbers, but not for all others. I am wanting to call the data one at a time depending on what id # is entered on a form. Here is the code so far.

 

$query = "SELECT `comment` FROM MY_comments WHERE `id`=".$_POST['comment_id']." ";
                $result = mysql_query($query);
                
                if(empty($result) || !$result){
                	print "No Results Found For Comment ID#:".$comment_id;
                	exit;
                }

                $record = mysql_fetch_assoc($result);
                $comment1 = $record["comment"];

 

[tommyda]

try mysql_fetch_array instead of assoc

[PFMaBiSmAd]

You need to use mysql_num_rows to find out how many rows there are in the result set. The if(){} conditional test you have now only checks if the query executed without any errors or failed and the posted query will only fail if $_POST['comment_id'] is empty. $result will either be a FALSE value (the query failed to execute due to an error) or a result resource (the query executed without any errors) anyway so empty($result) will always be false.