Re: foreign key

[Peter Lind <peter.e.lind@xxxxxxxxx>]

On 9 August 2011 21:23, Chris Stinemetz <chrisstinemetz@xxxxxxxxx> wrote:
>
>
> >>
> >
> > 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

So you're saying that
SELECT 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

returns

Chris Stinemetz 08-09-2011 02:08PM 600kbps-3.8mbps test
Chris Stinemetz 08-09-2011 02:08PM 600kbps-3.8mbps test
Chris Stinemetz 08-09-2011 02:07PM 0-250kbps test1
Chris Stinemetz 08-09-2011 02:07PM 0-250kbps test1

>From the above, can't see where your problem is but something in your
join is obviously not unique - whether it's the first or second table.

--
<hype>
WWW: plphp.dk / plind.dk
LinkedIn: plind
BeWelcome/Couchsurfing: Fake51
Twitter: kafe15
</hype>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php