From: Scott Swaim [mailto:[EMAIL PROTECTED] > 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.
You've now posted this four times today. Was that on purpose? I can only assume so, as some people have absolutely no sense of netiquette whatsoever. Why, you ask, has no one replied with the infinite wisdom to solve your problem? I, for one, haven't because your original email is at least vaguely unintelligible. Have I asked for more information so that I might be more helpful? No, I've been busy. Posting over and over and over again, though, seems to have worked, so readers, take note -- if at first you don't succeed, try, try again until you annoy someone into listening. *sigh* That said, sir, could you possibly provide more details for your situation? Your code is a bit jumbled. We have no idea what pv() does, for instance. Nor db_query(). These are not standard PHP functions, so you'll have to forgive us if we're all a bit clueless and unwilling to help. -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]