Array troubles....

[bgosse]

Hello,

Been pulling my hair out over this one.
First.. I can't figure the arrays out... but this is what i seek.

I have a table with just two columns, date and count.

I want to fill an array like this;

$data = array(
"Jan" => 55,

...
"Dec" => 71);

but the from a table.

Tried it with;

$db = mysql_connect("h","u","p");
mysql_select_db("db1",$db);

$result = mysql_query("SELECT * FROM table", $db);
$num_rows = mysql_num_rows($result);

Laat alleen de laatste week zien

$show_rows = $num_rows - 7;

$result2 = mysql_query("SELECT * FROM table LIMIT $show_rows,-1");

$data = mysql_fetch_array($result2);

What am I doing wrong....

If someone could help me out on this one....
I'll send u a x-mas card :o)

Thanks in advance

[Anon]

for this part: $result2 = mysql_query("SELECT * FROM table LIMIT $show_rows,-1");

$data = mysql_fetch_array($result2);

you should have it set to:
$result2 = mysql_query("SELECT * FROM table LIMIT $show_rows,-1");
while($data = mysql_fetch_array($result2))
{
$something[] = $data["column_you_want_data_from"]
}

That puts the info into an array: $something[]

Hope that helps!

[Anon]

Sorry! I forgot one thing:

for the:

while($data = mysql_fetch_array($result2))
{
$something[] = $data["column_you_want_data_from"]
}

I thought it would be easier to understand if I showed you with your actual fields:
while($data = mysql_fetch_array($result2))
{
$date[] = $data["date"];
$count[] = $data["count"];
}

to see if it worked try this:

$counter = count($date);

for($i = 0; $i < $counter; $i++)
{
print $date[$i] . "-" . $count[$i];
}

Once again, hope I helped! Tell me if I did!

[bgosse]

Thank you very much for you fast response...
I get the idea now... unfortunately this does not seem to be what i want.

This is what i want to get from a query;
$data = array(
"Jan" => 55,
"Feb" => 54,
"Mar" => 53,
"Apr" => 33,
"May" => 13,
"Jun" => 15,
"Jul" => 23,
"Aug" => 28,
"Sep" => 32,
"Oct" => 45,
"Nov" => 73,
"Dec" => 71);

I can fill the first or the second but can't merge 'em.

I thought this should work ...

$result2 = mysql_query("SELECT * FROM table LIMIT $show_rows,-1");
while($dataset = mysql_fetch_array($result2))
{
$data1[] = $dataset["kol1"] ;
$data2[] = $dataset["kol2"] ;
$data[] = array_merge($data1,$data2) ;
}

Damn arrays... should have become a carpenter :o)