mysql_fetch_row doesn't work on new serv

[Anon]

I am moving my website from one server to another which is hosted by the same company. On the orginal server the following query worked fine:
$db = mysql_connect("localhost", "user", "pass");
mysql_select_db("database name", $db);
$a = mysql_query("SELECT id, number, name FROM headings ORDER BY number", $db);
while ($myrow = mysql_fetch_row($a)); (this is line 15)
{printf ("<A HREF = \"DisplayProducts.php?x=%s\">%s</A><P>\n", $myrow[0], $myrow[2]);}
When uploaded to new server it says not a valid resource result on line 15. I changed mysql_fetch to mysql_query and I can at least see the header on the page but I can not see the links to the product pages which is what this code did on the old server. What am I missing?

Thanks in advance for the help

[seansd]

I would suggest verifying the query works in mysql first. has the database data been reloaded yet?

[Anon]

I realized last nite that the data from the old server is not on the new server. So I am looking into trying to transfer the data or I am going to have to build a new database. Being that there is no data leads me to believe that when I ran the query in mysql it gave me an error message. Do you know of any way to transfer data from one database to another that are on two different servers?
Thank you
Gail

[seansd]

check on using the mysqldump utility.

[Anon]

i was but in the mean time my webhost switched the old database onto the new server so now everything works. Thanks for your time and info.
Sincerely,
Gail