Php error
The below error[see below for code] is done due to no data in database tables or due to NULLs ? is it about data integrity ?
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result
resource in /home/content/p/o/l/polisch123/html/indexaffv.php on line 139
Warning: mysql_free_result(): supplied argument is not a valid MySQL result
resource in /home/content/p/o/l/polisch123/html/indexaffv.php on line 142
Unable to execute query. Please try again later.
code:questionsCode:$query14 = "SELECT * FROM $AVisitorsTable WHERE countNumVisitor='$countNumVisitor'"; $result14 = @mysql_query($query14,$linkid); $row = mysql_fetch_assoc($result14); // line 139 $HasAccountDB = $row['HasAccount']; //$HasAccountDB=mysql_result($result14,0,"HasAccount"); mysql_free_result($result14);
for a query return only ONE row may use either of:
[these can also used in a loop]
1. $row = mysql_fetch_assoc($result14); $HasAccountDB =
$row['HasAccount'];
2. $HasAccountDB=mysql_result($result14,0,"HasAccount");
???


Reply With Quote
Bookmarks