[SOLVED] inserting from sql to array

[sarahAria]

I have the data for a class in below table (it's a class schedule and it draws the array on the week array)

CREATE TABLE schedule(
program TEXT NOT NULL,
duration TEXT NOT NULL,
day TEXT NOT NULL,
clock TEXT NOT NULL
);

 

& I need an array that should be like below (If I write below the array works)

$classes_arr = array(
    // Classes for monday (day 1)
    $r[day] => array(
            $r[clock] => array(
                "html" => ".$r[program].", 
                "style" => "background-color: #66CCCC", // use style property to change the background color
                "interval" => $r[duration] // set the interval for 2hrs
            )
    )
);

 

now I need to put data from sql to the array ND PRODUCE AN ARRAY LIKE above one

the final code should be like this

...
$classes_arr = array();
while ($row=mysql_fetch_assoc($result)) {
    extract($row);
    $classes_arr = array(
        $day => array(
            'clock' => '$clock',
            'html' => '$program',
            'style' => "background-color: #66CCCC",
            'interval' => '$duration') );
}

but it doesn't work any help? :'(

thanks Sarah

[Jibberish]

Whats going wrong? are you getting an error? are no results coming back from the SQL query? etc.

[Maq]

Try echoing your values out to make sure they're correct.  Also put:

 

ini_set ("display_errors", "1");
error_reporting(E_ALL);

 

At the top of your page for temporary error display.

 

 

[sarahAria]

the array seems to be empty!

 

 

[attachment deleted by admin]

[sarahAria]

there seems to be an error with array cause even by replacing values with constants nothing changes?!!?

unfortunately I don't know much about arrays  :'(

 

$classes_arr = array();
while ($row=mysql_fetch_assoc($result)) {
    extract($row);
    $classes_arr = array(
        0 => array(
            12 => array (
            'html' => '$program',
            'style' => "background-color: #66CCCC",
            'interval' => '120') ));

[Barand]

don't put the variables inside single quotes

 

$clock = '1230';

echo '$clock';     //--> $clock   !!!
echo $clock;       //--> 1230
echo "$clock";     //--> 1230

[sarahAria]

thanks solved