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

date posted 22nd January 2007 20:48

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
>>
>>
>>