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.