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
