|
|
Posted by Mark Sargent on 05/13/05 06:22
Richard Lynch wrote:
>
>
>On Thu, May 12, 2005 12:17 am, Mark Sargent said:
>
>
>>Hi All,
>>
>>ok, this revised code produces the error below,
>>
>><?php
>>
>>
>
>You took out the mysql_connect completely???
>
>Don't do that.
>
>
>
>>mysql_select_db("status",$db);
>>$maker_result = mysql_query("SELECT Makers.maker_id Makers.maker_detail
>>FROM Makers",$db);
>>
>>
>
>if (!$maker_result) die(mysql_error());
>
>
>
>>$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.
>>*
>>
>>--
>>PHP General Mailing List (http://www.php.net/)
>>To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>>
>
>
>
>
Hi All,
all is well.
1st Query
<?php
$db = mysql_connect("localhost", "root", "grunger");
mysql_select_db("status",$db);
$result = mysql_query("SELECT ProductTypes.product_type_detail,
ProductTypes.product_type_id FROM ProductTypes",$db);
$num = mysql_num_rows($result);
?>
<select name="slct_product_type">
<?php
for ($i=0; $i<$num; $i++){
$myrow=mysql_fetch_array($result);
$product_type=mysql_result($result,$i,"product_type_detail");
$product_type_id=mysql_result($result,$i,"product_type_id");
echo "<option value=\"$product_type_id\">$product_type</option><br>";
}
?>
</select>
2nd Query
<?php
$maker_result = mysql_query("SELECT Makers.maker_id, Makers.maker_detail
FROM Makers",$db);
if (!$maker_result) die(mysql_error());
?>
<select name="slct_maker">
<?php
$maker_num = mysql_num_rows($maker_result);
for ($i=0; $i<$maker_num; $i++){
$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>
Thanx for everyone's patience. Cheers.
Mark Sargent.
Navigation:
[Reply to this message]
|