I want to create an array from results returned from a mysql query. I want it to go through each row in the returned result, and if the variable in the array staff exists add 1 to the total, if it doesnt exist, set it as one and carry on.

But when i run this and do var_dump, it just returns "1" in the array for every date.

I don't think my logic for this is correct, please help.
$query = "SELECT * FROM Rota WHERE date >= $start and date <= ($start + INTERVAL 6 DAY) ";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)){
$x = 1;
$date = $row['Date'];
if ( isset($staff[$date] ) ){
$staff[$date] = $staff[$date] + $x ;
$staff[$date] = $x ;


It's fast, it's easy and it's free. Get MSN Messenger today! http://messenger.msn.co.uk

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

Reply via email to