A array to create another array

[LiL|aaron]

Hey

Im having a small issue here... been wracking my brain all day, im using a 3rd party script that creates graphs, i am having problems trying to input an array data.

The graph will display how many bookings went out for a castle.

$database = $db2;
include 'cp_dbconnect.php';
include 'functions/phpgraphlib.php';
    
$castleQuery = mysql_query("SELECT * FROM castles"); 
while ($crow = mysql_fetch_array($castleQuery)) {

    $castleName = $crow['Castle_Name'];
    $bookQuery = mysql_query("SELECT * FROM bookings WHERE Booking_Castle = '$crow[id]'");   
    $numBookings = mysql_num_rows($bookQuery);     
    
    $results[] = '"'.$castleName.'"=>-'.$numBookings;

}
    
    $cresults = count($results);
    
    $d = 'array(';
    while (list($key,$valuea) = each($results)) {
    if ($key+1 == $cresults) {
    $last = '';
    } else {
    $last = ', ';
    }
    
    echo "$valuea$last";
    // $t = "$valuea$last";

    }

    $a = ');';
    
    $graph = new PHPGraphLib(500,350);
    $data = "$d$t$a";
    
    echo $data;

    $graph->addData($data);
    $graph->setTitle('Test');
    $graph->setGradient('red', 'maroon');
    $graph->createGraph(); 

In the echo... it shows it correctly...

"12x15 Ben 10"=>-1, "12x15 Peppa Pig"=>-2

but when i try and make it a variable so i can use it else where it only shows the last one.

"12x15 Peppa Pig"=>-2

In the end this is what i am hoping.

$data = array("12x15 Ben 10"=>-1, "12x15 Peppa Pig"=>-2);

But i cannot manually input this, as it is getting the data from MySQL

Please help its getting annoying!! Thanks

[LiL|aaron]

I tried changing it around but its only showing 1 again

<?php
$database = $db2;
include 'cp_dbconnect.php';
include 'functions/phpgraphlib.php';
    
$castleQuery = mysql_query("SELECT * FROM castles"); 
while ($crow = mysql_fetch_array($castleQuery)) {

    $castleName = $crow['Castle_Name'];
    $bookQuery = mysql_query("SELECT * FROM bookings WHERE Booking_Castle = '$crow[id]'");   
    $numBookings = mysql_num_rows($bookQuery);     
    
    $results[] = '"'.$castleName.'"=>-'.$numBookings;

}
    
    $cresults = count($results);
    
    while (list($key,$valuea) = each($results)) {
    if ($key+1 == $cresults) {
    $last = '';
    } else {
    $last = ', ';
    }
    
    $rdata = "$valuea$last";
    $data = array("$rdata");
        
    }
        
    print_r ($data);
    
    $graph = new PHPGraphLib(500,350);
    $graph->addData($data);
    $graph->setTitle('Test');
    $graph->setGradient('red', 'maroon');
    $graph->createGraph();

?>

[LiL|aaron]

Dont worry ... worked it out