The Little Guy Posted December 4, 2006 Share Posted December 4, 2006 Currently I'm learning Join, and when I do this I get this error:[b]Unknown column 'display_images.owner_id' in 'field list'[/b]Everything is spelled correctly, I copied and pasted.Here is what I have, anything wrong?:[code]$sql2=mysql_query("SELECT users.user_id, display_images.owner_id FROM users, default_images WHERE users.user_id='$row[friend_id]' AND display_images.owner_id='$row[friend_id]'")or die(mysql_error());[/code] Link to comment https://forums.phpfreaks.com/topic/29358-mysql-join/ Share on other sites More sharing options...
The Little Guy Posted December 4, 2006 Author Share Posted December 4, 2006 Never mind, I found what was wrong. Link to comment https://forums.phpfreaks.com/topic/29358-mysql-join/#findComment-134641 Share on other sites More sharing options...
keeB Posted December 4, 2006 Share Posted December 4, 2006 It's polite to post the solution, for future reference, so that people searching with same problems can find some great insight. Link to comment https://forums.phpfreaks.com/topic/29358-mysql-join/#findComment-134662 Share on other sites More sharing options...
The Little Guy Posted December 4, 2006 Author Share Posted December 4, 2006 Ok... I copied and pasted, but not to all of them.It should be default_images, not display_images. Link to comment https://forums.phpfreaks.com/topic/29358-mysql-join/#findComment-134676 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.