Re: Multiple SELECT
| From: | Pablo M. Rivas | Date: | Tue, 13 Jul 2004 18:11:59 +0000 |
| Subject: | Re: Multiple SELECT | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35228@lists.php.net to get a copy of this message | ||
Hello Marcjon,
do this:
"SELECT forumusers.*, forumuserprofiles.* from
".$godlyness['database_database'].".forumusers
LEFT JOIN ".$godlyness['database_database'].".forumuserprofiles ON
forumusers.username = forumusersprofiles.username where .... order
by...."
so.. if you do: where forumusers.username like "%doe%"
you will receive all users like "%doe%", and null values if she/he
has not profile.
http://dev.mysql.com/doc/mysql/en/JOIN.html
M> "SELECT
M> forumusers.email AS email,forumusers.username AS username,forumusers.level AS level,
M> forumusers.lastlogon1 AS lastlogon1,forumusers.lastlogon2 AS
M> lastlogon2,forumusers.settings1 AS settings1,forumusers.confirmationcode AS confirmationcode,
M> forumuserprofiles.sex AS sex, forumuserprofiles.birthdate AS birthdate,
M> forumuserprofiles.address_msnm AS address_msnm, forumuserprofiles.address_aim AS
M> address_aim,
M> forumuserprofiles.address_yahoo AS address_yahoo, forumuserprofiles.address_icq AS
M> address_icq
M> FROM
M> ".$godlyness['database_database'].".forumusers,".$godlyness['database_database'].".forumuserprofiles
M> ".$filterbu."
M> ORDER BY username
M> "
--
Best regards,
Pablo