Arrays :(

[Kinneh]

Hiya,

I have a mysql table called i_results and a field in that table called date.

I need to get every row from the field date so say i have 20 rows, i need to put 20 dates into the array. Each date shud also have a value of 1.

$datearray = array (
'2003-1-12' => 1,
'2003-2-12' => 1,
'2003-2-13' => 1,
'2003-2-14' => 1,
'2003-2-15' => 1,
'2003-3-18' => 1,
'2003-3-7' => 1
);

Has to be in that format above ^.

Any ideas how to do this wud be mucho appreciated.

[rIkLuNd]

<?php

// connection to the database here!

$sql = 'select * from i_results';
$result = mysql_query($sql) or die(mysql_error());

while($data = mysql_fetch_array($result)) {
   $dateArray[$data['date']] = 1;
}

echo "<pre>";
print_r($dateArray);
echo "</pre>";

?>

[Kinneh]

Cheers! that worked a treat.

[Kinneh]

Another question 🙂

How would i get the dates from multiple tables in an sql database.

mysql_query("select date.tablea, date.tableb from tablea, tableb") ?

2nd question)

In table i_results there are 2 fields called date & opponent_tag.
With some help i can successfully get all the date values from the rows into an array, but i also want to get opponent_tag in as well. So say i have a row with date 2003-9-9 and opponent_tag ClanName how would i link the date in the array with the opponent_tag?