[PHP-DB] Problem with JOIN

2003-02-04 Thread HÃ¥kan Larsson
Hi there. Im making a kind of a messageboard and trying to save some time with the querys but i cant get it to work properly. I have two tables, one with some users and one with messages. Table : users +--++ | username | id | +--++ | user1| 1 | | user2| 2 | |

[PHP-DB] Problem with JOIN

2002-05-23 Thread andy
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 5 records of the website table: