Doesn't work, get unexpected { for if( $res->numRows() {. If I remove
braces or rearrange them it fall apart piece by piece.
Thanks for the try
Gary
Marek Kilimajer wrote:
> 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