Error while fetching the array

Question

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'] . " "; 

     } ?>

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

The error message is pretty clear. Whatever $services is, it is not a valid MySQL result resource. Edit: It is already the result array (as you can see at the output), so no need to use mysqli_fetch_assoc. Just iterate normally over the array. — Felix Kling
– Felix Kling, Commented Jul 10, 2011 at 23:21
@umar: It is a valid array, but not a valid MySQL result resource. That is something different. — Felix Kling
– Felix Kling, Commented Jul 10, 2011 at 23:24
@umar: I already said, use a normal for or foreach loop to iterate over the array. viewTask_front_android already gave you the result. There are no DB functions involved anymore. — Felix Kling
– Felix Kling, Commented Jul 10, 2011 at 23:26
Btw. you might want to read this (especially the return value part) to learn what a MySQL result research actually is. This will help you understand that it is not an array. — Felix Kling
– Felix Kling, Commented Jul 10, 2011 at 23:30

Ribose · Accepted Answer · 2011-07-10 23:25:08Z

3

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.

answered Jul 10, 2011 at 23:25

Ribose

2,23316 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dejan Marjanović · Accepted Answer · 2011-07-10 23:31:49Z

1

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

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

answered Jul 10, 2011 at 23:31

Dejan Marjanović

19.4k7 gold badges54 silver badges67 bronze badges

Collectives™ on Stack Overflow

Error while fetching the array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related