PHP mysql_fetch_array doesnt work?

Question

Im trying to fetch an array out of a Mysql query result :

    $result = mysqli_query($con,"SELECT * FROM names");

    if (!$result) {
   echo "WRONG";
}
    var_dump($result);

      //Fetch the data in a loop
      while($r=mysql_fetch_array($result, MYSQL_ASSOC)){

        var_dump($r);

      }

var_dump($result); shows me that there is something in it :

object(mysqli_result)#2 (5) { ["current_field"]=> int(0) ["field_count"]=> int(6) ["lengths"]=> NULL ["num_rows"]=> int(2) ["type"]=> int(0) }

but why i never get a:

var_dump($r); call

you are mixing mysqli with mysql.

Abhik Chakraborty
– Abhik Chakraborty

2014-04-25 09:27:14 +00:00
Commented Apr 25, 2014 at 9:27 — Abhik Chakraborty
– Abhik Chakraborty, Commented Apr 25, 2014 at 9:27

gbestard · Accepted Answer · 2014-04-25 09:27:54Z

2

You are mixing mysql_ functions with mysqli_ functions

Change your fetch to

$r = mysqli_fetch_array()

answered Apr 25, 2014 at 9:27

gbestard

1,17713 silver badges30 bronze badges

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

Comments

user3563052 · Accepted Answer · 2014-04-25 09:32:47Z

1

You did mistake in mysql_fetch_array while($r=mysqli_fetch_array($result, MYSQL_ASSOC)){

    var_dump($r);//write mysqli_fetch_array

  }

answered Apr 25, 2014 at 9:32

user3563052

Collectives™ on Stack Overflow

PHP mysql_fetch_array doesnt work?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related