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