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?! */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php