Re: foreign key

>> > > What does your result look like? Hard to say what the problem is > without seeing the result. > I am echoing the query and printing the get array just for debugging purposes, but below you can see how it is repeating its' self. Thank you Array ( [id] => Bella Roe 4980 Roe Blvd ) Bella Roe 4980 Roe BlvdSELECT stores.store_subject, stores.store_comments, stores.store_date, stores.store_tptest, stores.store_by, users.user_id, users.user_name, users.first_name, users.last_name FROM stores LEFT JOIN users ON stores.store_by = users.user_id WHERE stores.store_subject = 'Bella Roe 4980 Roe Blvd' ORDER BY stores.store_date DESC Chris Stinemetz 08-09-2011 02:08PM600kbps-3.8mbps testChris Stinemetz 08-09-2011 02:07PM0-250kbps test1Reply: Bella Roe 4980 Roe BlvdSELECT stores.store_subject, stores.store_comments, stores.store_date, stores.store_tptest, stores.store_by, users.user_id, users.user_name, users.first_name, users.last_name FROM stores LEFT JOIN users ON stores.store_by = users.user_id WHERE stores.store_subject = 'Bella Roe 4980 Roe Blvd' ORDER BY stores.store_date DESC Chris Stinemetz 08-09-2011 02:08PM600kbps-3.8mbps testChris Stinemetz 08-09-2011 02:07PM0-250kbps test1Reply: