Thank you Chris for that answer. I did not know if it was a mysql problem or php problem.
Again I apologize (especially to Mike Johsnon) for the multiple request. I was getting a return error on the list and I thought it was a configuration error on my part. I did not mean to upset anyone. Thank you again for the answer and I will try to have better netiquette in the future. ----- Original Message ----- From: "Chris" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Wednesday, April 21, 2004 4:54 PM Subject: RE: re-using a results set > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
