I've searched about possible solutions to this. and I've tried looping as well as trying the variants of mysql_fetch_assoc and mysql_fetch_array but I'm still getting the Resource id #5: 0: error.
Here's my code which I think generates the error.
<?php
mysqlc();
$email = GetSQLValueString($_SESSION['user'], "text");
$query = sprintf("SELECT * FROM newmember WHERE email = %s",$email);
$res = mysql_query($query) or die('Query failed: ' . mysql_error() . "<br />\n$sql");
$row = mysql_fetch_assoc($res);
?>
"Resource id #5: 0" is not an error. It means that you tried to echo $res
instead of trying to use the $row
variable, such as $row[column] for fetch_assoc, $row[0] for fetch_row, either/both for fetch_array.
The other answers explain the use of mysql_fetch_*
Also, mysql_* is deprecated. You should use mysqli_* or PDO functions instead.