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 ...

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

Reply via email to