Hi.
I am having a problem with a webpage, sometimes it works, and sometimes i receive an error like:
"Query Failed
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /usr/local/www/www.mysite.com/index4.php on line 13"
THis is the code:
<? session_start();
$session_id = session_id();
?>
<?php require_once('Connections/superbrands.php'); ?>
<?php
function QueryIntoArray($query){
settype($retval,"array");
$result= mysql_query($query);
if(!$result){
print "Query Failed";
}
for($i=0;$i<mysql_numrows($result);$i++){
for($j=0;$j<mysql_num_fields($result);$j++){
$retval[$i][mysql_field_name($result,$j)] = mysql_result
($result,$i,mysql_field_name($result,$j));
}//end inner loop
}//end outer loop
return $retval;
}//end function
?>
<?php
settype($myresult,"array");
$query = "SELECT * FROM superbrands1 WHERE session_id = '$session_id' ORDER BY votos1 DESC limit 7";
$myresult = QueryIntoArray($query);
for($i=0;$i<count($myresult);$i++){
$marc = $myresult[$i]["marcas"];
$vot = $myresult[$i]["votos1"];
$sessao = $myresult[$i]["session_id"];
mysql_query ("INSERT INTO inovador (marcas, votos2, session_id, familiar) VALUES ('$marc','$vot','$sessao','1')");
}
?>
Can any one help me out?
Thanks,
Manuel
