Does anyone know if this between statement will work?
tdout is a timestamp
newtimein & newtimeout is a preformatted time like 2000-3-9 24:0:0 &
$command = << "EOC";
timedata.totalsec FROM timedata, timeusers
WHERE timeusers.userid = timedata.connectid AND timedata.status="Out"
timeusers.userid=$newid AND timedata.tdout BETWEEN $newtimein AND
I tend to think that the Between statement is in the wrong place?
I am trying to grab records that fall between certain dates and I ahve
settled for allowing the user to
set the between dates because I don't understand how to code weekly
What I would like is an output to html that would simply allow weekly
records per web page, so there would be a row of number that would be
links to the pages as well as show how many pages of weekly records
Too much to ask for?
|• Help with Between Statement||Douglas Brantz||17 Mar|