Hi all...
I'm having a problem with getting results from a MySQL query back into PHP as something usable.
I am trying to do some date arithmetic on some timestamp fields. When I do the query from the mysql client, I get the proper results and the calculations are presented in the results as, what looks like, a field name.
When I run the query:
select a_gw, z_gw, work_order, approver_name,
(TO_DAYS(closed_date) - TO_DAYS(submission_date)),
(TO_DAYS(mgt_auth_date) - TO_DAYS(submission_date)),
(TO_DAYS(approval_date) - TO_DAYS(mgt_auth_date)),
(TO_DAYS(closed_date) - TO_DAYS(approval_date))
from expedite
where ( ( TO_DAYS(closed_date) - TO_DAYS(submission_date) ) > 30 )
and case_status = 'Closed'
order by approver_name \G
I get the expected following results:
************************ 1. row ************************
a_gw: city one
z_gw: city two
work_order: xxxx-001
approver_name: Joe Schmoe
(TO_DAYS(closed_date) - TO_DAYS(submission_date)): 33
(TO_DAYS(mgt_auth_date) - TO_DAYS(submission_date)): 0
(TO_DAYS(approval_date) - TO_DAYS(mgt_auth_date)): 33
(TO_DAYS(closed_date) - TO_DAYS(approval_date)): 0
The PHP code I am using is posted below. You'll also notice the <--- where I am getting the parse error.
<?php
$mtd_ip_query = mysql_query("select a_gw, z_gw, work_order, approver_name,
(TO_DAYS(closed_date) - TO_DAYS(submission_date)),
(TO_DAYS(mgt_auth_date) - TO_DAYS(submission_date)),
(TO_DAYS(approval_date) - TO_DAYS(mgt_auth_date)),
(TO_DAYS(closed_date) - TO_DAYS(approval_date))
from expedite
where ( ( TO_DAYS(closed_date) - TO_DAYS(submission_date) ) > 30 )
and case_status = 'Closed'
order by approver_name") or die ("ARRRGGG! I just puked!");
if ( $myrow = mysql_fetch_array($mtd_ip_query) ) {
do (
printf("
<tr>
<td align=left>%</td>
<td align=right>-</td>
<td align=right>-</td>
<td align=right>-</td>
<td align=right>-</td>
<td align=right>-</td>
<td align=right>%</td>
</tr>\n", $myrow[approver_name], $myrow[(TO_DAYS(closed_date) - TO_DAYS(approval_date))] ); <--- parse error
) while ( $myrow = mysql_fetch_array( $mtd_ip_query ) );
}// end of mtd_ip
I guess what I am getting at is how to pass the results of the MySQL date calculations back to PHP to stick in my table?
Thanks all!
--->Rob
