Problem with LEFT JOIN

[snowboardr]

I can't seem to get this to work! It does display records, however they are all the same person.

I have two tables

users / friendlist

friendlist:

fid | fidon | fidlisted
1 3 4
2 3 5
3 3 6
4 3 7


users:

uid | uname
4 jason
5 bob
6 eric
7 smith


I want to display every friend's name from the table friendlist with a fidon id=3

	sql = "SELECT "_
		& "friendlist.fidon," _
		& "friendlist.fidlisted," _
		& "users.uid," _
		& "users.uname" _
		& " FROM friendlist LEFT JOIN users on friendlist.fidlisted=users.uid WHERE friendlist.fidon=" & fuid

Thanks in advance.

 

[KarveR]

Are you passing it the '3'?

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[snowboardr]

yes

fuid is the variable 3

friendlist.fidon=" & fuid


the odd thing is, i tried running the below query in a mysql gui, and it selects correctly, but when i do it in the browser, its only showing 1 name?

im confused.

SELECT friendlist.fidon,friendlist.fidlisted,users.uid,users.uname FROM friendlist LEFT JOIN users on friendlist.fidlisted=users.uid WHERE friendlist.fidon=3

 

[r937]

if your query works fine in mysql, and doesn't work in your scripting language (php?), then guess where the problem is



r937.com | rudy.ca

 

[guelphdad]

You are probably not using a WHILE or FOR loop to display your results properly in PHP. Take a look in the php.net manual for mysql_fetch_row, mysql_fetch_array, mysql_fetch_assoc depdending on which one you are using and make sure you follow the example accordingly.