Re: FN-FORUM: MySQL Query only showing 1 record

date posted 22nd January 2007 20:41

I think I have something preventing all records showing due to the value

WHERE ca.county = "value"
AND ccl.company_id = ca.company_id
AND ca.company_id = cr.company_id
AND ca.company_id = cp.company_id
AND ccl.category_id = 108';





----- Original Message -----
From: "Chris Hill" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Monday, January 22, 2007 9:07 PM
Subject: Re: FN-FORUM: MySQL Query only showing 1 record


>
> other than only one record matching your query, obviously... (sorry -
> best to rule out everything!)
>
>
>
> Punters Power wrote:
>> is there any reason why an
>>
>> while($row = mysql_fetch_array($result)){
>>
>>
>> would only show one record?
>>
>> Andrew
>>
>>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>