[EMAIL PROTECTED] wrote: > > 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.
There are two ways to solve this problem. One is to build your select box differently, so that it passes the data as firstname/lastname or firstname|lastname or with some other delimiter, then split the data before entering/examining it. If you're stuck with the current behavior, though, try: select [fields] from [table] where concat([firstname],[lastname]) is [value]; -- John Klein, Database Applications Developer | Omnia Mutantur, Systems Group - Harvard Law School | Nihil Interit --------------------------------------------------------------------- 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
