Jump to content

select from 2 tables


AviNahum

Recommended Posts

hey,

i trying to select * colums form one table and 1 colum from another table...

this is my code:

	$DB->query("SELECT m.*, v.time, v.viewerid
                              		  FROM members m
                                		  LEFT JOIN profile_views v ON (m.id=v.userid)
                                		  WHERE m.id IN ({$viewers_ids})");

 

but sometimes this query return multiply rows...

any ideas?

 

Thanks!

Link to comment
https://forums.phpfreaks.com/topic/216709-select-from-2-tables/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.