Re: Multiple SELECT
| From: | Jason Wong | Date: | Mon, 12 Jul 2004 03:26:10 +0000 |
| Subject: | Re: Multiple SELECT | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35200@lists.php.net to get a copy of this message | ||
On Monday 12 July 2004 10:31, Marcjon wrote:
> Oh yeah, I tried doing a
> WHERE forumusers.username=forumuserprofiles.username
> It worked, but if I added a AND forumusers.username = 'search string
> here' it didn't return anything.
This should work if your 'search string here' *exactly* matches one of the
'username'. You may want to look at the LIKE operator.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
Isn't this my STOP?!
*/