Re: PHP/MySql Help

On Wed, 9 Apr 2003 17:35:38 EDT UGADawgs6910@aol.com wrote: > 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')); should be: $insert = mysql_query($query) or die ('im a piece')); > $number = MYSQL_NUM_ROWS($query); and replace $query with $insert for above: $number = MYSQL_NUM_ROWS($insert); > 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 DEFANGED_border='\"0\"' > DEFANGED_cellpadding='\"2\"' > cellspacing=\"0\" style=\"border-collapse: collapse\" > width=\"100%\"> > <tr> > <td DEFANGED_width='\"100%\"' > DEFANGED_bgcolor='\"#003366\"' > DEFANGED_colspan='\"6\"'><font > DEFANGED_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 > -- Edmond Baroud Senior UNIX sysadmin mailto:SoHo@admin.fido.ca Fingerprint 140F 5FD5 3FDD 45D9 226D 9602 8C3D EAFB 4E19 BEF9 "UNIX is very user friendly, it's just picky about who its friends are."