leonidassavvides
04-07-2009, 07:46 PM
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:
$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);
questions
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");
???
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:
$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);
questions
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");
???