> ...which will echo:
> "<tr><td>#records in 't7solar_landing' matching the given (iterating)
> date (in the 'solarLandingDateTime' column)</td><td>#records in
> 'aw_7solar_confirm' matching the given (iterating) date (in the
> 'solarAwConfDateTime' column)</td><td>#records in 'aw_7solar_aw'
> matching the given (iterating) date (in the 'solarAWDateTime'
> column)</td></tr>"...
If you just need to count the records with a particular date you should be able
to use this construction:
SELECT COUNT(*) AS `record_count`,
DATE(<date_column>) AS `date_field`
FROM <table>
GROUP BY `date_field`
You could probably write a generalized PHP function (called 'build_query()' or
something) that would construct this query given a table name and a date-column
name, and call it once for each table/column pair.
Then you could stitch the three query strings together, in PHP, into one large
query using SQL's "UNION ALL", which concatenates the results of multiple
queries into one large result-set:
(<query 1>) UNION ALL (<query 2>) UNION ALL (<query 3>)
And then pass that one large query to the database.
> So I need to read/learn more MySQL. Can you guys point me to where in the
> mysql docs I should be burying myself?
In my experience the MySQL manual isn't a great resource for learning SQL, at
the level you're looking for. It's a fine reference if you already have a solid
understanding of the basics. But to get that understanding, you might try the
O'Reilly book called "Learning SQL":
http://oreilly.com/catalog/9780596520830/?CMP=AFC-ak_book&ATT=Learning+SQL%2c+Second+Edition%2c
Someone else here might know of some good online resources. I've not seen any,
but then I haven't spent a whole lot of time looking. The parts of "Learning
SQL" that I've seen are excellent.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
