# Grabbing a bunch of rows as a array

**URL:** <https://forum.kirupa.com/t/grabbing-a-bunch-of-rows-as-a-array/55131>\
**Category:** Uncategorized\
**Created:** [June 21, 2004, 12:59pm UTC](https://forum.kirupa.com/t/grabbing-a-bunch-of-rows-as-a-array/55131 "2004-06-21T12:59:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![iloveitaly](https://avatars.discourse-cdn.com/v4/letter/i/7ea924/32.png) [@iloveitaly](https://forum.kirupa.com/u/iloveitaly)\
**Post date:** [June 21, 2004, 12:59pm UTC](https://forum.kirupa.com/t/grabbing-a-bunch-of-rows-as-a-array/55131/1 "2004-06-21T12:59:37Z")

</div>

can you do this? in PHP that is…  
here is a example:

```php
<?
if($db = mysql_connect("localhost", "database", "pass")){
mysql_select_db("thedatabase",$db);
}
$result = mysql_query("SELECT entry FROM mab", $db);
$num = mysql_num_rows($result);
while($info = mysql_fetch_row($result)){
echo"$info[0]<p>";
}
mysql_close($db);
?>

```

I cant get ANY function to fetch a bunch of rows as a array, i’ve tried:  
mysql\_fetch\_row  
mysql\_fetch\_array  
mysql\_fetch\_assoc

and a few others…  
anyways my question is, is there a way to return a COLUMN in a MYsql databse as a array?
