Still having some problems.
Can anyone see why this just returns all zeros for the counts? Here is a SAMPLE of the query part:
$month[1]['name'] = 'January';
$row = mysql_fetch_array(mysql_query('select COUNT() from Client001 where SERVICE LIKE "'.$SERVICE.'%" and month="'.$MONTH['name'].'" and 31_EXPECTED="A"'));
$month[1]['A'] = $row['COUNT()'];
And here is a SAMPLE of the display part:
<TR>
<TD>Better than Expected</TD><TD><?php echo $month[1]['A'];?></TD><TD><?php echo $month[2]['A'];?></TD><TD><?php echo $month[3]['A'];?></TD><TD><?php echo $sum[1];?></TD>
</TR>
As you can see, I'm not even sure which end has the problem. Or could it be on my html search page which submits the request? There I have a select 1 of 4 from the Service menu (which I think is working alright), but there may be a problem with my checkboxes for the months.
Also need a little help with:
1.) "looping" through the rest of the months (Each month in a new column, not row).
2.) "adding" more months in the results table if/when they select more than 3 months. (I'm currently set up for 3 ... but need to somehow make that auto-generate the <td></td>'s, depending on how many they select.)
3.) Making sure my check boxes for the months on my html search form are set up for "multiple select" (assuming that can be done) and then incorporating that search criteria in my php page.
Boy! I must seem like an idiot to all of you, but I admit that I'm very new to this and I think I'm in over my head!
Thanks for any (more) help you can give. Several of you have already helped me A LOT!
Laurie
