Detail of Errors
[php_everywhere]
Record Detail
‘;
while ($row = mysqli_fetch_array($dr, MYSQLI_ASSOC)) {
$newrow = array_map(‘ucwords’, $row);
echo ‘
‘.$newrow[‘YEAR(sessions.date_con)’].’
‘.$newrow[‘title’].’
‘.$newrow[‘bill_type’].’
‘.$newrow[‘bill_no’].’
‘.$newrow[‘bill_title’].’
‘.$newrow[‘pub_act_no’].’
‘.$newrow[‘sp_act_no’].’
‘.$newrow[‘name’].’
‘;
} //end while loop
//echo ‘‘;
/*
$cq = “SELECT committees.name FROM committees INNER JOIN billcomm ON committees.id=billcomm.id INNER JOIN errors ON billcomm.session_id=errors.session_id && billcomm.bill_type=errors.bill_type && billcomm.bill_no=errors.bill_no INNER JOIN sessions ON errors.session_id=sessions.session_id WHERE sessions.date_con=\”$session\” && errors.bill_type=\”$type\” && errors.bill_no=\”$number\””;
$cr = @mysqli_query($dbc, $cq);
if ($cr) {
while ($res = mysqli_fetch_array($cr, MYSQLI_ASSOC)){
echo ‘
‘.$res[‘name’].’
‘;
//’
Bill Details
‘ . $res[‘name’] . ‘
‘; }//end while loop }*/ } else { //error message echo ‘There has been an error, and the data could not be retrieved.
‘; //debugging message //echo ‘‘ . mysqli_error($dbc) . ‘
Query: ‘ . $q . ‘