I have created a PHP report with 7 sql queries. I want to display the result set on a HTML page driven by timestamp (I used one timestamp from 1 query to loop the result in order to get an entry per day)but since some queries do not have results for certain dates, the result set for different queries do not align up with the proper dates. Here is an example:
Query 1 returns:
Timestamp Visitors
07-02-01 399
07-01-01 98
06-30-01 234
06-29-01 456
06-28-01 988
06-27-01 897
06-26-01 988
06-25-01 897
06-24-01 345
However, query 2 returns:
Timestamp Rfp_awarded
07-02-01 5
06-30-01 8
06-29-01 3
06-27-01 82
06-25-01 49
06-24-01 26
When you join these 2 queries together in a php report, I got sth like this
Timestamp Visitors Rfp_awarded
07-02-01 399 5
07-01-01 98 8
06-30-01 234 3
06-29-01 456 82
06-28-01 988 49
06-27-01 897 26
06-26-01 988
06-25-01 897
06-24-01 345
Do you know how I can solve this problem?
thanks in advance,
Kevin
Query 1 returns:
Timestamp Visitors
07-02-01 399
07-01-01 98
06-30-01 234
06-29-01 456
06-28-01 988
06-27-01 897
06-26-01 988
06-25-01 897
06-24-01 345
However, query 2 returns:
Timestamp Rfp_awarded
07-02-01 5
06-30-01 8
06-29-01 3
06-27-01 82
06-25-01 49
06-24-01 26
When you join these 2 queries together in a php report, I got sth like this
Timestamp Visitors Rfp_awarded
07-02-01 399 5
07-01-01 98 8
06-30-01 234 3
06-29-01 456 82
06-28-01 988 49
06-27-01 897 26
06-26-01 988
06-25-01 897
06-24-01 345
Do you know how I can solve this problem?
thanks in advance,
Kevin