|
|
Posted by Joe (GKF) on 04/15/07 03:53
I have data arranged in weekly blocks starting on Sunday. I wanted to
use date("W") as a selector/ trigger (whatever the correct term is) but
it starts the week on MONday. I'm going around in circles trying to
solve this problem, which I am sure is not as difficult as I am making
it.
Having the site hosted on the other side of the International Date Line
isn't helping my head either...
my data base looks like fifty-two records containing
weeknum,sundaystuff, mondaystuff,...etc
and the php is
(part)
$thisweek=date("W") ;
if ($thisweek > 52) { $thisweek=1;}; /*because the year is longer than
52weeks*/
$result = mysql_query("SELECT * FROM alltext where
weekofyear='$thisweek' ")
or die("Bad query: " . mysql_error());
echo '<p>This is week ' .($thisweek) ;
while($row = mysql_fetch_array($result))
(do some stuff)etc.
Help!
--
http://graspages.cjb.cc/
Navigation:
[Reply to this message]
|