Jump to content
xisto Community
Sign in to follow this  
pbrugge

Mysql Errors cant find whats wrong :(

Recommended Posts

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 :rolleyes:

[/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

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

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 :rolleyes:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.