[thelist] php/mysql : selecting all rows that match a date range
Luther, Ron
Ron.Luther at compaq.com
Fri Jan 4 17:10:21 CST 2002
Hi John,
Congrats! Looks like the added "AND films.filmID = showings.filmID"
where condition got rid of your duplicates. [Which makes sense ... as
things like this usually do --- afterwards!] ;-)
Yep - that ole 'date add' function can be very useful!
RonL.
(Who did quite a bit of playing around with dates this week - writing an
app that dynamically pulls data from the last two months - but had to
straddle year-end boundaries because one table contains 12 months of
data for "this year" and a different table contains 12 months of data
for "last year". {Oh, and 'completed months' only get written to the
table on the 8th of the following month - so today 'last month' is
November instead of December!} Wheeeee!)
-----Original Message-----
From: John Corry [mailto:john at neoncowboy.com]
To see this query in action, visit:
http://members.evolt.org/webshot/query_test.php?query=
More information about the thelist
mailing list