开发者

Error while fetching the array

I have the following code which is generating error while fetching the elements of the array

 $task = new task();
    $task->connect();
    $services = $task->viewTask_front_android($_GET['pno']); 
    print_r($services);
     while($info =  mysqli_fetch_assoc($services)) 
     { 
     Print "<b>Name:</b> ".$info['starttime'开发者_如何学Python] . " "; 

     } ?>

from the print_r(services) iam getting

Array ( [task_id] => 14 [user_id] => 123 [employee_id] => 456 [service_id] => 2 [starttime] => 2:00 AM [endtime] => 4:00 AM [servicename] => se a [servicedescription] => ddsdsd [employeename] => dsd [employeepicture] => pictures/noimage.gif [pic_path] => pictures/noimage.gif ) 

is there any problem with while($info = mysqli_fetch_assoc($services)) it is generating error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\proj\android\services.php on line 70


It looks like

$services = $task->viewTask_front_android($_GET['pno']); 

is already returning an array (a single row, from appearance). You don't/can't fetch an array from it as if it were the result of mysql_query, because it's not.

Instead, just print $services['starttime']:

print "<b>Name:</b> ".$services['starttime'] . " ";

Edit: If I was unclear, remove the while loop completely as well.


No need for loop, it returns one dimensional array...

Print "<b>Name:</b> $services[starttime] "; 
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜