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
