get array of values from db instead of hard coding?

[carolc]

I have a few lines of code that work, but I want to be able to read from the database instead of hardcoding

Part that works:

$input = array("14","78","29","45","32");
$rand_keys = array_rand($input, 2);


but instead of hardcoding the values in the array, I'd like to read from the database

Query I want to use:

"SELECT id FROM `tablename` where catid=1"

Is mysql_fetch_array the right command to use? If so, I can't quite get it to work. Or is there a better command? I see data if I do a while loop (below), but not sure how to do anything else

(while loop that shows I'm at least retrieving data)
while ($row = mysql_fetch_array($result, MYSQL_NUM))
{
printf("ID: %s", $row[0]);
}

How do I populate $input with an array of values from my sql statement?

Thanks

[kh99]

If that while loop is printing out the right data then I think you just need


while ($row = mysql_fetch_array($result, MYSQL_NUM))
{
$input[] = $row[0];
}

[carolc]

Where's the 'Thank' button, lol. That worked perfectly!

Thanks!