Re: PHP/MySql Help

On Wed, 9 Apr 2003 UGADawgs6910@aol.com wrote: > Do you know why the following code wouldn't work? > > mysql_connect ("localhost", "crosse5_stringdo", "******") or die > ('I cannot > connect to the database because: ' . mysql_error()); > mysql_select_db ("crosse5_stringdoctororders"); > > > $insert = MYSQL_QUERY("SELECT ordernumber, name, emailaddy, > dateupdate, timeupdate, stickstatus, received, predicted, express, mail, > headnum, pocket, notes, payment FROM tracker where > ordernumber='$OrderNumber'"); > ?> > > I have no idea, please help! > if (!$insert) { print 'Could not run query: ' . mysql_error(); exit; } Also, it would be very helpful if you told us the specific error and/or problem otherwise we can just blindly say something like "You don't have a table named tracker" or "You must use mysql_fetch_assoc or similar to retrieve values" or ... And please read this (both text and example): http://www.php.net/mysql_fetch_assoc Regards, Philip