Unable to jump to row 0 on MySQL result...

[acctman]

I know what the problem is, the is not picture record, but how do I suppress/skip this error

$en['i_id'] = mysql_result(mysql_query("SELECT i_id FROM rate_pictures WHERE i_status='2' AND i_user='".$en[msg_sender]."'"), 0, "i_id");

[Maq]

Put an @ symbol in front of "mysql_result".

 

If you want to suppress the error why don't you just take out the entire line?

[acctman]

Put an @ symbol in front of "mysql_result".

 

If you want to suppress the error why don't you just take out the entire line?

 

its looping though, so i'd like for it to just bypass the records with no images but display all the other ones. i read somewhere about using mysql_num_rows() to check and display only rows with data. but i'm not sure how to apply that

[Maq]

You can just do:

 

if($en['i_id'] = mysql_result(mysql_query("SELECT i_id FROM rate_pictures WHERE i_status='2' AND i_user='".$en[msg_sender]."'"), 0, "i_id")) {
   // Proceed
} else {
   // Invalid
}

[acctman]

You can just do:

 

if($en['i_id'] = mysql_result(mysql_query("SELECT i_id FROM rate_pictures WHERE i_status='2' AND i_user='".$en[msg_sender]."'"), 0, "i_id")) {
   // Proceed
} else {
   // Invalid
}

 

last question is it bad to escape out non-errors with the @ sign?

[Maq]

last question is it bad to escape out non-errors with the @ sign?

 

It's good to suppress errors on a production server, but when you're trying to debug then you want to see these errors so you can fix them.