arrays

[webAmeteur]

I am trying to vrate a 2d array, inputting a value from a database.

I have used this code:

<?php
$seats = array( array());
for ($i=0; $i<=20; i++)
{
for ($j=0; $j<=5; $j++)
{
$seats[$i][$j] = $row_rstAvailSeats['seat_number'];
}
}
?>

When I load the page though it displays nothing. Have i defined the array correctly??

Regards

[xblue]

your code just creates the array. it would not output it unless you tell it to do, e.g. with print_r($seats);

btw, whatever $row_rstAvailSeats['seat_number'] is, it will always be the same during the loops since you never change it.

[webAmeteur]

Thanks, I have just realised where I was going wrong.

rst_AvailSeats['seat_number'] is a query from a recordset in dreamweaver.

This is the code Ihave now modified:

<?php
do {

?>
<?php
$seats = array();

		$seats[$rows] = $row_rstAvailSeats['seat_number'];

?>
<?php
} while ($row_rstAvailSeats = mysql_fetch_assoc($rstAvailSeats));
$rows = mysql_num_rows($rstAvailSeats);
if($rows > 0) {
mysql_data_seek($rstAvailSeats, 0);
$row_rstAvailSeats = mysql_fetch_assoc($rstAvailSeats);
}
?>

I now have this array with seats 1 to 100 in it, but need to somehow pass these values into a 2d javascript array.

So the array would look something like this, with seat number indicated in the middle.

---

| 1 | 2 | 3 | 4 | 5 |

| 6 | 7 | 8 | 9 | 10 |

etc etc.. down to 100.

Please help

Kind regards

[xblue]

hi again,

bubblenut recently posted quite a lot of probably most helpful code to generate javascript arrays from php arrays:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10292116