[PHP/MySQL] MySQL to Array

[Axon]

Hey Guys,

I really need some help quickly if possible, I need to know how to take information from a database and put it into a PHP array.

Thanks!

-Ax

[bizpile]

$connection = mysql_connect($db_host, $db_user, $db_pass) or die(mysql_error());
$db = mysql_select_db($db_name, $connection) or die(mysql_error());
$sql= "SELECT * FROM $table";
$sql_results = mysql_query($sql, $connection) or die("Couldn't execute query");

while($row=mysql_fetch_array($sql_results, MYSQL_ASSOC))
	$arr[]=$row;

[Axon]

Thanks for the fast reply,

I should have been more clear as to what I was looking to accomplish,

here is a picture of my database, and a highlited column, I want to select only the date and one column at a time!

Thanks for the fast reply!

-Ax

[epton]

But if you're only selecting one date and one column at a time then why do you need an array?

$sql= "SELECT t_air FROM $table WHERE date = 'whatever'";

[Axon]

I want to put the date and the corrosponing information into an array. :)

array {

"2005-03-01" "4.91"

"2005-02-12" "2.01"

"2005-10-15" "5.10"

}

ect

Thanks for replying!

-Ax

[GatorV]

Well you can acomplish it like this:

<?php
// Connect and stuff
$query = "SELECT date, t_air FROM kcwks_raw";
$result = mysql_query( $query );
$data = array();
while( $row = mysql_fetch_array( $result ) )
     $data[] = array( $row[0], $row[1] );
// Disconnect
?>

then on data you will have a array were each item is an array with the data you need..