> At 11:55 23/09/01 +1000, you wrote:
> Thanks Will for the suggestion, however as per my private email to you, it
> didn't work successfully to any degree. Actually it knocked out ONE date
> from the "same" group and that was one of the Available dates.
I'll take my foot out of my mouth now and try and look at what I'm doing!
Thanks Will, you were spot on. The sql example you provided did exactly
what it was suppose to, I just didn't add all the extra grouping and so
when I looked, only one date showed as valid in the table. Which, ungrouped
is correct :)
Thanks also Will, for all the extra bits you added, I'll go over those now
and start to build a slightly more complex processing list now
incorporating all the locations, cast, crew and other resources needed and
of course, now the dates will show up by group :)
/me pulls foot out of mouth and looks at ALL data, rather than an assumed
snapshot :)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
