Re: Inner Join or 2nd Query...?
| From: | Mark Sargent | Date: | Thu, 12 May 2005 07:17:07 +0000 |
| Subject: | Re: Inner Join or 2nd Query...? | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-215021@lists.php.net to get a copy of this message | ||
Hi All,
ok, this revised code produces the error below,
<?php
mysql_select_db("status",$db);
$maker_result = mysql_query("SELECT Makers.maker_id Makers.maker_detail FROM Makers",$db);
$maker_num = mysql_num_rows($maker_result); //Line 40?> <select name="slct_maker"> <?php for ($i=0; $i<$maker_num; $i++){ $maker_myrow=mysql_fetch_array($maker_result); $maker=mysql_result($maker_result,$i,"maker_detail"); $maker_id=mysql_result($maker_result,$i,"maker_id"); echo "<option value=\"$maker_id\">$maker</option><br>"; } ?> </select> *Warning*: mysql_num_rows(): supplied argument is not a valid MySQL result resource in */var/www/html/products.php* on line *40 Cheers. Mark Sargent. *