pbrugge 0 Report post Posted October 18, 2004 I am working on my guestbook, better to say I am transfuring it from old to new site, but I got some errors now I did not had at my old hoster and I cannot figure out whats wrong: [/br]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pbrugge/public_html/guest.php on line 104[br][/br]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pbrugge/public_html/guest.php on line 110[br] This is the complete relevant code perhaps I overlooked something but I keep overlooking it [/br]if(!$rowstart) $rowstart=0;[br][/br]$result = mysql_query("select * from gbook order by id desc limit $rowstart,20");[/br]$result2 = mysql_query("select * from gbook");[br][/br]$numrows = mysql_num_rows($result2);[br][/br][br]//set backfire list[br][/br][/br]while($r=mysql_fetch_array($result))[br][/br]{[br] echo "<div class='ginfo'>Posted By:[/br] <a href='mailto:$r[email]'>$r[name]</a></div>";[br] echo "<div class='gmes'>$r[message]</div>";[/br]} Which mysql - php guru can help me with this? Share this post Link to post Share on other sites
OpaQue 15 Report post Posted October 18, 2004 Definately something wrong with the mysql code or the syntaxIt can also happen if the version is old. Share this post Link to post Share on other sites
pbrugge 0 Report post Posted October 18, 2004 Definately something wrong with the mysql code or the syntaxIt can also happen if the version is old.Old version of what mysql?It hosted here so I guess mysql version is oke, script is my own so there's no version number there Share this post Link to post Share on other sites
pbrugge 0 Report post Posted October 18, 2004 Arg found it it was a problem with the database_user rights I did set it a little to strict, works now, Told ya it would be something stupid Share this post Link to post Share on other sites