$example_data = array(
array('a',1),
array('b',2),
array('c',3)
);


$sql = "SELECT * FROM `table`";
$results = mysql_query($sql);

while( $row = mysql_fetch_assoc($results) ) {

     $array[] = $row;

}