what about
if( $res->numRows() {
while( $row = $res->fetchRows() ){
... do what you've got to do
}
} else {
... no rows
}
Gary wrote:
> John W. Holmes wrote:
>
>>> John W. Holmes wrote:
>>>
>>>
>>>>> Can someone tell where I messed up on this code snippit?
>>>>>
>>>>
>>>> Your first mistake is not giving us the full error and the line
>>>> number...
>>>>
>>>>
>>>>
>>>>
>>>>> if ($res->numRows() > 0){
>>>>> list($id, $question, $responce1,
>>>>>
>>>>
>>>> $responce2,
>>>>
>>>>
>>>>
>>>>> $responce3) = $res->fetchRows()
>>>>>
>>>>
>>>> and you're missing a ; here... ^^
>>>>
>>>>
>>>>
>>>>
>>>>> $id = $row[0];
>>>>> $question = $row[1];
>>>>> $responce1 = $row[2];
>>>>> $responce2 = $row[3];
>>>>> $responce3 = $row[4];
>>>>> }
>>>>>
>>>>
>>>> ---John Holmes...
>>>>
>>>>
>>>>
>>>
>>> that fixed the unexpected t_variable but now it is Fatal error: Call
>>>
>>
>> to
>>
>>
>>> undefined function: fetchrows()
>>>
>>> list($id, $question, $responce1, $responce2,$responce3) = $res-
>>>
>>>
>>>> fetchRows()
>>>>
>>>
>>
>> That means there is no function fetchrows() associated with whatever
>> class $res comes from...
>>
>>
>
> I think it is time to call it a day. It is 11pm and I am getting so
> punchy from this long day, I forgot to say it is a db call using
> pearDB. If I remove the code and replace it with while ($row =
> $res->fetchRows()) along the row array it work but then I can't check
> for > 0
>
>
> Sorry
> Gary
>
>>
>>
>>
>>
>>
>
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
