How do I get the data from a mysql database into and array that looks like this Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5 [5] => 6 ) The table has three fields but I only need the data from one field. $query="SELECT amenityID FROM property_amenity where listingId = '$listingId'"; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php