[RESOLVED] dynamic array from mysqldb

[knucklehead]

hello, i have an array which looks like this:

$days = array(

    11=>array('../program.php?m=07#2006-07-11','linked-day'),

    13=>array('../program.php?m=07#2006-07-13','linked-day'),

    15=>array('../program.php?m=07#2006-07-15','linked-day'),

//etc


);

but what i need is to read from table and 'construct' each value, like this;

$query = mysql_query("SELECT * FROM program ORDER BY datum ASC") or die(mysql_error());

while ($row = mysql_fetch_array($query)) {
$datum_explode = explode("-",$row["datum"]);
$array = $datum_explode[2]."=>array('../program.php?m=07#".$row["datum"]."','linked-day'),<br>";
}

$days = array(

$array

);

so, can i make that simple as i think or should i use array_push to construct my array? please, any help would be great 🙂 thanks!

[laserlight]

Not quite, since you are not inserting into your associative array properly. It is more likely to be something like:

$query = mysql_query("SELECT * FROM program ORDER BY datum ASC") or die(mysql_error());

$array = array();
while ($row = mysql_fetch_array($query)) {
    $datum_explode = explode("-",$row["datum"]);
    $array[$datum_explode[2]] = array('../program.php?m=07#' . $row['datum'], 'linked-day');
}

[knucklehead]

hmm that was close but still not what i need...
also, i got really wierd output when i do print_r($array):

Array (
[15] => Array ( [0] => ../program.php?m=07#2007-07-15 [1] => linked-day )
[16] => Array ( [0] => ../program.php?m=07#2007-07-16 [1] => linked-day )
[17] => Array ( [0] => ../program.php?m=07#2007-07-17 [1] => linked-day ) )
Array (
[0] => Array ( [15] => Array ( [0] => ../program.php?m=07#2007-07-15 [1] => linked-day ) [16] => Array ( [0] => ../program.php?m=07#2007-07-16 [1] => linked-day ) [17] => Array ( [0] => ../program.php?m=07#2007-07-17 [1] => linked-day ) ) )

so i changed your code little bit and i hope that i'm going in right direction;

$query = mysql_query("SELECT * FROM program ORDER BY datum ASC") or die(mysql_error());

$array = array();
while ($row = mysql_fetch_array($query)) {
	$datum_explode = explode("-",$row["datum"]);
    $array[$datum_explode[2]] = "array('../program.php?m=07#" . $row['datum']."','linked-day'),";
        }

and print_r($array) now looks like this:

Array (
[15] => array('../program.php?m=07#2007-07-15','linked-day'),
[16] => array('../program.php?m=07#2007-07-16','linked-day'),
[17] => array('../program.php?m=07#2007-07-17','linked-day'),
)

what is really similar to the original array from the first post;

$days = array(
11=>array('../program.php?m=07#2006-07-11','linked-day'),
13=>array('../program.php?m=07#2006-07-13','linked-day'),
15=>array('../program.php?m=07#2006-07-15','linked-day'),
//etc
); 

so, how to get those numbers without [] brackets? and how should i create $days array with printed values? just like this maybe:

$days = array(
$array
);

[laserlight]

so, how to get those numbers without [] brackets?

Those brackets are just pretty printing of print_r(). In fact, it looks like you are getting confused between what your values really are and how they look when you do a print_r(). Give this a try:

<?php
$days = array(
    11=>array('../program.php?m=07#2006-07-11','linked-day'),
    13=>array('../program.php?m=07#2006-07-13','linked-day'),
    15=>array('../program.php?m=07#2006-07-15','linked-day'),
    );
print_r($days);
?>

Clearly the print_r() output is not exactly the same as what you wrote in PHP. If you really want the print_r() type output, then you are no longer working with arrays, but with a single string.

[knucklehead]

hmmm, that's interesting to know 🙂 at the end i have to apologize once more for my dumbness but your first tip was good..... the problem was only in variable names (i should rename $array to $days and everything worked)
thank you very very very much for help!