Re: PHP/MySql Help

Thanks for the help, but it still isn't working... I am not sure exactly of the problem, the thing is I am getting no error messages I am just not getting any of the variables back below... it is getting past the connect phase, and I tested out the query in PHPMyAdmin and it works. I've checked it over and over so I have no idea. I suppose the error must be in these lines: $insert = mysql_result($query or die ('im a piece')); $number = MYSQL_NUM_ROWS($query); if($number != 0) { $i = 0; $ordernumber = mysql_result($insert,$i,"ordernumber"); $emailaddy = mysql_result($insert,$i,"emailaddy"); } or down here: if($number != 0) {echo ("<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" style=\"border-collapse: collapse\" width=\"100%\"> <tr> <td width=\"100%\" bgcolor=\"#003366\" colspan=\"6\"><font color=\"#FFFFFF\"> $name - $emailaddy: Order Number: $ordernumber</font></td>..... Thanks for the help, I wish I had more info to give you about the error. I know that $number is being returned as 0, if that helps at all. Thanks guys -Daniel