mysql database problem

[mendhak]

I recently changed servers, and now when I try to access my guestbook, I keep getting this error:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/mendhak/public_html/guestbook/index.php on line 51

For some reason, mysql_numrows, is not... valid/recognized???
Here's the code:

<?php
global $offset; // the string will be in the URL, say index.php?offset=9
if($offset==0 OR $offset==""){
$offset=0;
}


$dbh=mysql_connect("localhost", "mendhak_hello", "hello") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db("mendhak_thewebsite"); 

$displayperpage = 5; //set this variable to the number of records you want per page.

$sqloffset=$offset*$displayperpage;




$query="SELECT * FROM guestbook ORDER BY id DESC LIMIT $sqloffset,$displayperpage";
$countquery="SELECT COUNT(*) FROM guestbook";

$result=mysql_query($query);

$pagecount=mysql_query($countquery);
$rowsonthispage=mysql_numrows($result);
//[b][color=black]THIS IS LINE 51[/color][/b]



$tempcount = mysql_fetch_row($pagecount);

$num = $tempcount[0];   //now we have total records

[techgnome]

First thing I would do is findout what version of MySQL is running on the server, and then find out if the command in question is supported in that version.

[mendhak]

Ok, it turned out to be a missing column in the table, which is why the argument being received was invalid.

Thanks anyways.

[The Hobo]

Originally posted by mendhak

For some reason, mysql_numrows, is not... valid/recognized???
Here's the code:

I know you fixed this already, but just a little FYI: that error is telling you that the supplied resource is not valid, not that the function itself is invalid.

So when you were missing your column, your mysql_query() was not returning a valid result.

[mendhak]

Originally posted by The Hobo
I know you fixed this already, but just a little FYI: that error is telling you that the supplied resource is not valid, not that the function itself is invalid.

So when you were missing your column, your mysql_query() was not returning a valid result.

Thanks for the info.
I had another question. On both servers, I had phpMyadmin (the web based mySQL admin thing).

Now, I was wondering if it's possible for me to take a backup of the database, along with the tables and values stored in it? I know how to do this in SQL Server, which is what I used previously. But I don't know how to do this in mySQL.

Any ideas?

[phpman]

first, mysql_numrows is deprecated and shouldn't be used.

second, in phpmyadmin there is a export link. just select what you want "structure and data" and save it as a zip or sql file. either way will be sql file when done. then just upload the sql file in the new phpmyadmin adn it will install everything.

[techgnome]

Originally posted by phpman
second, in phpmyadmin there is a export link. just select what you want "structure and data" and save it as a zip or sql file. either way will be sql file when done. then just upload the sql file in the new phpmyadmin adn it will install everything.

I've done that before.... it' pretty handy for creating "backups".... depending on the size if the DB, you may want to do it inbatch of a few tables at a time. I had a problem once, where the host had a veryshort timeout period, and so tables that took a while to script (because of the #of rows), I got TO errors when I scripted them w/ other tables.

[phpman]

very true, if a very big database than you would want to do it one table at a time.

[The Hobo]

Originally posted by phpman
first, mysql_numrows is deprecated and shouldn't be used.

I'm going to invent a language so I can randomly deprecate functions and create new ones with extra underscores in them.

[phpman]

that's what is seems like huh? but in fact you can't even find it in the manual anymore so, deprecated, heck it is gone

[The Hobo]

Originally posted by phpman
that's what is seems like huh? but in fact you can't even find it in the manual anymore so, deprecated, heck it is gone

Indeed, although there is a reference to it under mysql_num_rows(), but that just says that it's deprecated.

[phpman]

where does it say that

http://www.mysql.com/doc/en/mysql_num_rows.html#IDX1606

[CornedBee]

Here
http://www.php.net/manual/en/functio...l-num-rows.php

[mendhak]

Alright,
if mysql_numrows() is depreciated, then what do I use instead?

It's important that I get the number of rows, after all, it's for the guestbook, and I do ned the 'sorting' scheme I'm implementing.

Second, I have winmysqladmin, which is a pain in the ass to say the least. Where can I get phpmyadmin from?

[phpman]

use mysql_num_rows()

and

www.phpmyadmin.net

[The Hobo]

Originally posted by CornedBee
Here
http://www.php.net/manual/en/functio...l-num-rows.php

Also in the downloadable .chm documentation.

[phpman]

that is funny, because I ooked at mysql.com and you would think they would now what is in there program and what is not. they dont' even list it.

[mendhak]

Jeez, mysql_numrows() and mysql_num_rows() differ by one friggin' under_score. I really don't see what difference it makes, other than causing the inconvenience of having to change that single line in several pages of my site. (Thank you PHP.NET)


Thanks guys, I'll try out phpmyadmin.

[The Hobo]

Originally posted by phpman
that is funny, because I ooked at mysql.com and you would think they would now what is in there program and what is not. they dont' even list it.

phpman...mysql_num_rows() is a PHP function, not a native MySQL function.

[CornedBee]

In the old PHP API for mysql it was mysql_numrows(). Then the name was changed to mysql_num_rows() so that it is the same as the native mysql function that phpman found.

[lejohn]

may be error at server, my script is ok on this server but error at
other. report your problem to server admin

[The Hobo]

Originally posted by lejohn
may be error at server, my script is ok on this server but error at
other. report your problem to server admin

He already fixed his problem. Read the third post.

[MikkyThomeon]

HI All

Since this thread is over a year aol and you guys know more php than I do, I wish to ask you this:

I have recently installed RH Linux 8 using the server installation option of the RH installer. PHP works fine and MySQL works fine. I have a problem when using MySQL connect in that an undefined function error is returned when i try to use:

$conn = mysql_connect("localhost");

I am logged in as a root user and there are no database permissions present yet. I think apache is not finding a module of sorts. Any help here would be really appreciated.

Thanks
Mike

[phpman]

what version of php are you using? and you really should start another thread.

[phpman]

what version of php are you using? and you really should start another thread.

[MikkyThomeon]

Sorry about the posting , but you can find the new thread here