AutoGallery SQL question...

[cd34]

use php

<?php

echo date("l");
echo date("l",time() - (1* 86400));
echo date("l",time() - (2* 86400));
echo date("l",time() - (3* 86400));
echo date("l",time() - (4* 86400));
echo date("l",time() - (5* 86400));
echo date("l",time() - (6* 86400));

?>


although I really hate doing date calculations on every pageload -- especially 7 of them

you could also do the same thing with an array, find the current position, cycle through and set the variable.