Urgent MYSQL_FETCH_array doesnt work

skmit87

Hi All,

i am facing the following issue in my code below:
$dbQuery = "SELECT * from product where Title=\"$blobId\"";

        $query_result=mysql_query($dbQuery) or die (mysql_error());
        echo $query_result; //I see that a "resource Id 2 is coming up


$result =  mysql_fetch_array($query_result) or die('no such data') ; //Its always saying no such data though the above query works fine in MYSQL command prompt.

If you see the Mysql_fetch_arraly always goes into the die mode. It is to be noted that the above query works in Mysql command prompt. Also the $query_result has value as resource id #2. What seems to be the problem here kindly guide me...

TobyRT

What's the actual error you're getting?
echo $query_result should just return "array()"
If you've got an array you'll need to iterate through it to see what you need.
My preferred method is:

while ($result = mysql_fetch_array($query_result)) {
echo $result['field1'].'<br />';
echo $result['field2'].'<br />';
//etc. etc.
}

bradgrafelman

You should also consider using [man]mysql_num_rows/man to verify that there is anything to fetch before attempting to fetch it.

Finally, if you still aren't seeing the results you're expecting, try echo'ing out the SQL query and make sure it is what you think it is.

Bonesnap

If you're unsure what the issue is, echo the mysql_error() when it fails.

<?php
$result = mysql_fetch_array($query_result) or die(mysql_error());
?>

That will certainly give you a clue as to what the problem is. If the error is "not a valid resource" then there's usually something wrong with your query (period instead of a comma between column names, misspelled table or column name, etc.).

bradgrafelman;10966630 wrote:
Finally, if you still aren't seeing the results you're expecting, try echo'ing out the SQL query and make sure it is what you think it is.

This x100. I usually do this before actually putting in the mysql_query() function, especially if it's a long or complicated query, or if it's changing data (deleting, updating, etc.).