Hi there,
I do want to pull out some data of a user. I did normalize the tables, so
there is a table for website, comment ...
Advertising
Now I would like to pull out the users website, comment.. but only if there
is one.
Unfortunatelly my select stmt returns all 50000 records of the website
table:
SELECT
w.website,
c.comment,
i.icq,
s.signature
FROM
user_websites
LEFT JOIN user_comments AS c ON c.user_id = '3'
LEFT JOIN user_icq AS i ON i.user_id = '3'
LEFT JOIN user_signature AS s ON s.user_id = '3'
LEFT JOIN user_websites AS w ON w.user_id = '3'
Somehow my syntax must be wrong, but I can not find the error :-(
Maybe one of you guys does know why.
Thanx in advance,
Andy
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
