Joining two tables problem

[scmeeker]

I'm trying to join these two tables and its not pulling the information from the "product" table into the "store".  I'm not able to access info I requested from the "product" table.  Here is the code and hopefully you can help.  I'm rather new to PHP and MySql so your help is very appreciated. Thanks!!

 

$get_item_sql = "SELECT p.id, p.photo, p.username, p.title, p.date, p.location, p.store_id, s.store_id, s.username, s.store_name, s.location, s.news, s.websites FROM store AS s LEFT JOIN product AS p on s.store_id = p.id WHERE s.store_id = '".$_GET["store_id"]."'";

 

[scmeeker]

Resolved!  I changed the s.store_id = p.id to s.store_id = p.store_id.

 

Thanks anyway!