RE: [PHP] PHP/MySql Help
| From: | Jennifer Goodie | Date: | Wed, 09 Apr 2003 21:44:04 +0000 |
| Subject: | RE: [PHP] PHP/MySql Help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-143217@lists.php.net to get a copy of this message | ||
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
>