[PHP-DB] Multidimensional arrays / Dynamic variables

[David Rice]

Okay the problem is adding another result to the multi-dimensional array

When i perform var_dump on the returned varialbe $tips i get

array(1) {   [2]=>   array(1) {     [0]=>     string(10) "2003-03-07"   } }

I know that there are 2 results missing here for when the key of the array 
is 1 ($staffid = 1)
the results are such that the array should look like this

array(1) {     [1]=>   array(2) {     [0]=>     string(10) "2003-03-06"
                                                 [1]=>     string(10) 
"2003-03-07"   }
                  [2]=>   array(1) {     [0]=>     string(10) "2003-03-07"  
 }
            }

now I just need some help getting my code to produce the second output.
=================================================================
<?
function tips($weekstart){
	$start = date('Ymd',strtotime($weekstart));
	$query = "SELECT * FROM Rota WHERE date >= $start and date <= ($start + 
INTERVAL 6 DAY) ORDER BY staffid";
	$result = mysql_query($query);

_________________________________________________________________
Overloaded with spam? With MSN 8, you can filter it out 
http://join.msn.com/?page=features/junkmail&pgmarket=en-gb&XAPID=32&DI=1059

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php