[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