Making an array out of a while statement

[marcus]

How would I make an array out of a while statement

[code]
$sql = "SELECT * FROM `list_items` WHERE `type` ='food'";
$res = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($res)){
$row[item_id];
}
[/code]

and take the while statement stuff and put it into an array

[mkosmosports]

I think this would do it:

$sql = "SELECT * FROM `list_items` WHERE `type` ='food'";
$res = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($res))
{
$nameofarray[] = $row[item_id];
}

[marcus]

That would make it into an array as in array(); ?

[trq]

[code=php:0]
$sql = "SELECT * FROM `list_items` WHERE `type` ='food'";
$res = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($res)) {
  $array[] = $row['item_id'];
}
[/code]

[marcus]

Fatal error: Cannot use [] for reading in /home/kael/public_html/rs_cron/food.php on line 24

[marcus]

That happens when I try to echo it off.

[trq]

You cant simply echo an array. You need to use a loop.

[marcus]

How would I make it into the array? I don't understand this.

[emehrkay]

try this - same as thorpe's

$sql = "SELECT * FROM `list_items` WHERE `type` ='food'";
$res = mysql_query($sql) or die(mysql_error());
$array = array();
while ($row = mysql_fetch_assoc($res)) {
  $array[] = $row['item_id'];
}
print_r($array);

[trq]

This will make an array called $array out of all the rows selected from your database.

[code=php:0]
$sql = "SELECT * FROM `list_items` WHERE `type` ='food'";
$res = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($res)) {
  $array[] = $row['item_id'];
}
[/code]

Then, to display this array you'll need a loop, something like.

[code=php:0]
foreach($array as $val) {
  echo $val;
}
[/code]

As you may have noticed, making an array out of a database record like you asked is next to useless. Its more work for both you and php to create two loops.