PHP Getting select query output as array

Question

I've a select query say

 $query = "select name from class";
 $equery = mysql_query($query);
 $v = mysql_fetch_array($equery);    
 print_r($v['name']);

I've 10 records in my data base but always i'm getting only one value.is there any alternative to retrieve my column in array format.

Using mysql_query is probably a very bad idea as it's very hard to use correctly. Is there any reason you're not using mysqli or PDO? — tadman
– tadman, Commented Sep 27, 2012 at 15:12

xdazz · Accepted Answer · 2012-09-27 15:10:39Z

2

You need to loop it.

$query = "select name from class";
$equery = mysql_query($query);
$result = array();
while ($row = mysql_fetch_array($equery)) {
    $result[] = $row['name'];
}
print_r($result);

answered Sep 27, 2012 at 15:10

xdazz

161k38 gold badges255 silver badges278 bronze badges

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

Comments

lanzz · Accepted Answer · 2012-09-27 15:12:35Z

1

Do not use the mysql extension, as it has been deprecated. You should use mysqli_result::fetch_all with the mysqli extension, or PDOStatement::fetchAll with the PDO extension.

answered Sep 27, 2012 at 15:12

lanzz

43.4k12 gold badges93 silver badges99 bronze badges

Comments

Bud Damyanov · Accepted Answer · 2012-09-27 15:11:27Z

0

Put everything in a LOOP:

<?php

  while($v = mysql_fetch_array($equery);) {
  print_r($v['name']);
}
?>

answered Sep 27, 2012 at 15:11

Bud Damyanov

32.1k7 gold badges47 silver badges53 bronze badges

Comments

Sebastian Breit · Accepted Answer · 2012-09-27 15:11:32Z

0

 $query = "select name from class";
 $equery = mysql_query($query);

 $v=null;
 $index=0;
 while($row = mysql_fetch_array($equery,MYSQL_ASSOC)){
     $v[$index++]=$row;
 }

answered Sep 27, 2012 at 15:11

Sebastian Breit

6,1611 gold badge37 silver badges54 bronze badges

Comments

MatthewMcGovern · Accepted Answer · 2012-09-27 15:13:25Z

0

In addition to the other answers which are correct: You shouldn't really be using any of the old mysql commands as they are being depreciated. You should check out mysqli or PDO.

answered Sep 27, 2012 at 15:13

MatthewMcGovern

3,5062 gold badges24 silver badges19 bronze badges

Comments

geekman · Accepted Answer · 2012-09-27 15:16:30Z

0

You don't essentially need to loop it, if you have only one row in output, this way is fine, but if you have more, you need to loop.

$a=mysql_fetch_array($resource)

returns the first row, loop it

while($row=mysql_fetch_assoc($resource))
{
echo ($row['name']);
}

mysql_fetch_assoc returns output in form of associative array. i keep saying this on all mysql posts, try switching to PDO. USE of mysql_query is discouraged. It means it's support may soon be removed.

http://php.net/manual/en/function.mysql-query.php

answered Sep 27, 2012 at 15:16

geekman

2,25414 silver badges17 bronze badges

1 Comment

Elias Van Ootegem Over a year ago

It's not only discouraged, it's finally in the first stages of the long-awaited deprecation process :), it might even be at the stage of issuing warnings with E_STRICT | E_ALL set...

Collectives™ on Stack Overflow

PHP Getting select query output as array

6 Answers 6

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related