Hi!
I've got two nested queries where one looks up data based on values returned from the
first.
$lot_query = "SELECT * FROM LOT WHERE lot_category_id=" . $lot_category .
" AND lot_close_time>" . time();
$lot_result = mysql_query($lot_query, $CONNECT_ID);
if ($lot_result)
{
while ($row = mysql_fetch_array($lot_result))
{
blah-blah-blah...
$bid_query = "select * from bids where bid_lot_id=" . $lot_id .
" order by bid_amount";
$bid_result = mysql_query($bid_query, $CONNECT_ID);
$bid_count = mysql_num_rows($bid_result);
blah-blah-blah...
I get this error message: "Warning: mysql_num_rows(): supplied argument is not a valid
MySQL result resource " from the second query. Do I need a second $CONNECT_ID for a
second link to mysql_query #2??
Robin E. Kopetzky
Black Mesa Computers/Internet Services
www.blackmesa-isp.net
