> 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.
if you really don't know the difference between firstname and lastname how about something like: select * from mytable where (first_name=$first && last_name=$last) || (first_name=$last && last_name=$first) I suppose you could get duplicates if you have john+doe and doe+john. -Lance > > > > 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