Simple Mysql Query
June 23rd, 2011
Need php script to query mysql dbase.
Will look in one table for a date range (date in text format), then will take record IDs and query another table and return records from the table with same ID. Each record in the second table corresponds to one of a set number of items and a sum of each item should be given at the end. Any ID which has a record in the second table, which has certain fields that are zero value should be highlighted yellow.



