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:

PHP Code:

$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)

PHP Code:

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