RE: [PHP] PHP/MySql Help

Ignore this. I should give up on answering stuff today, I'm error prone or something. > -----Original Message----- > From: Jennifer Goodie [mailto:goodie@apollointeractive.com] > Sent: Wednesday, April 09, 2003 2:44 PM > To: UGADawgs6910@aol.com; php-general@lists.php.net > Subject: RE: [PHP] PHP/MySql Help > > > mysql_num_rows is expecting a result identifier, so try passing it $insert > instead of $query. > > > -----Original Message----- > > From: UGADawgs6910@aol.com [mailto:UGADawgs6910@aol.com] > > Sent: Wednesday, April 09, 2003 2:36 PM > > To: php-general@lists.php.net > > Subject: Re: [PHP] 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 > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >