Automatically generating arrays based on database columns

[monkeypaw201]

If I were to have a database with 20 columns, and wanted to query it and have an associative array called `table` automatically have all of the database columns added to it, how would I do that?

 

Meaning, later on in the script, I could call a specific value (each query is LIMIT 1)

 

echo $table['column3'];

[calmchess]

 

while($row = mysql_fetch_row($result){

array_push(table,$row[0]);

}

[Buddski]

If your calling query limit is 1

$table = mysql_fetch_assoc($sql_query);

will be fine

 

calmchess' method will only add the value of $row[0] into the array and not all the fields in the database..

[calmchess]

I've gotta read things more carefully.....sorry about the bad post.