Re: [PHP] Nested mysql_query()'s

2003-07-01 Thread James Hicks
No need for another connect as long as selecting from same server as the same user. Perhaps there are no bids for some of the lot_id's? Perhaps you do not care that there are bids returned and want to shut mysql_num_rows up by prepending the @ sign in front of it. Like @mysql_num_rows($bid_resul

[PHP] Nested mysql_query()'s

2003-07-01 Thread Sparky Kopetzky
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)