Have been wondering if this is possible....
Basically I have 3 posted arrays,
$_POST['reporton_company'] (this can be various company id's. ie 3,6,7)
$_POST['report_period'] (this can be various periods but a max of 4
submitted. ie 3,4,5)
$_POST['questions_groups'] (this can be various - starting from 1- whatever
(usually a max of 10 or 11). ie 1,2,3,4,5,6,7,8,9,10)
So the select should work as
1. for each company listed go through the loop
2. for each report period listed go through loop for each company
3. for each questions group go through the loop for each report period and
each company..
So I came up with this - will it work??
foreach($_POST['reporton_company'] as $cmp_ind =>$arrayd_cmp_id) {
foreach($_POST['report_period'] as $rep_ind =>$arrayd_per_id) {
foreach($_POST['questions_groups'] as $group_ind => $arrayd_group_no) {
mysql_select_db($database_name, $dname);
$query_get_list_of_answers = "SELECT * FROM answers LEFT JOIN (questions,
period) ON (questions.id=answers.ans_l_question_id AND
period.per_id=ans_l_period_id) where ans_l_company_id = '$arrayd_cmp_id' AND
per_id = '$arrayd_per_id' AND group_no = '$arrayd_group_no';";
$get_list_of_answers = mysql_query($query_get_list_of_answers, $antiva) or
die(mysql_error());
$row_get_list_of_answers = mysql_fetch_assoc($get_list_of_answers);
$totalRows_get_list_of_answers = mysql_num_rows($get_list_of_answers);
}
}
}
Anyone suggest an easier way?
Cheers
Chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
