This is a PHP question, not MySQL. http://www.php.net/mysql_data_seek
-----Original Message----- From: Scott Swaim [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 2:47 PM To: Mysql Subject: re-using a results set I have a form that does the following <? while ($speaker = mysql_fetch_object($qid_speaker)) { ?> <option value="<? pv($speaker->first_name) ?> <? pv($speaker->last_name) ?>"> <? pv($speaker->first_name) ?> <? pv($speaker->last_name) ?> <? } ?> </select> $qid_speaker = db_query("SELECT first_name, last_name FROM people WHERE speaker = 'Y' ORDER BY last_name"); I am using this in a form select drop down box. What I need to do is reuse this results set in another drop down box. but I can not figure out how to do this. If I use the mysql_free-result($qid_speaker) and then try to do the query again I get a mysql_fetch_object(): 12 is not a valid MYSQL result resource. TIA Scott Swaim Quality Corps, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
