moved host - mysql errors

wxdqz

New Member
I moved a domain from one hosting service to another, did a SQL schema dump from the first, and reloaded it on the second. Changed my database name, username and passwords in my scripts and everything works but one shopping cart call. This is the error:
Warning: Supplied argument is not a valid MySQL-Link resource in /home/domain/public_html/updatecart.php on line 19

Warning: Cannot add header information - headers already sent by (output started at /home/domain/public_html/updatecart.php:19) in /home/domain/public_html/updatecart.php on line 24

Warning: Supplied argument is not a valid MySQL result resource in /home/domain/public_html/updatecart.php on line 73

Following is line 18&19 from updatecart.php:

18:$result = mysql_query("INSERT INTO clients (randomNumber,created_date) VALUES(".$randomNumber.",'".$today."')");
19:$id = mysql_insert_id($result);

I'm a MySQL newbie but am ready to learn... any help would be appreciated to point me in the right direction.

Dean Martin
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
 
Back
Top