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

date posted 22nd January 2007 21:02

its a variation of another query but it definately pulls more than one using
the original


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


>
> thats a fairly specific SQL statement - i reckon its designed to just pull
> out one record based on the 'company_id' bit, which suggests unique
> identification...
>
> Punters Power wrote:
>> 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
>>>
>>>
>>>
>
> --
> 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
>
>