If this is web based, you could store the id of the record in the VALUE parameter of the OPTION tag
You could alternately create some kind of object(Vector, array, list whatever your language is) that would track the id and have that be along side of the select box, or perhaps your select box can even store an alternate value (that being the id) already -----Original Message----- From: Chuck Barnett [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 12:21 PM To: Rick Emery; [EMAIL PROTECTED] Subject: Re: Query help This will not work for my example. I have a select box that was populated from the db with firstname lastname. The option tag has the value of firstname+lastname then. Here lies the problem, when I build the query, I have no way of distinguishing firstname and lastname. Chuck ----- Original Message ----- From: "Rick Emery" <[EMAIL PROTECTED]> To: "'Chuck Barnett'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 11:06 AM Subject: RE: Query help > SELECT * FROM mytable WHERE first_name=$first && last_name=$last > > -----Original Message----- > From: Chuck Barnett [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 04, 2002 10:28 AM > To: [EMAIL PROTECTED] > Subject: Query help > > > Hi. I have two fields, firstname, lastname. I populate a select box with > the firstname lastname. Now when a user selects a name and hits submit, the > program will(should) select * from table where the selected name equal > firstname+lastname. I guess you have to some how put the first and last > name together and compare the selected name to it....I dunno > > Thanks for help with this query. > > Chuck > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
