RE: [PHP-DB] display values from to_char() function.
| From: | Jack van Zanen | Date: | Sat, 20 Sep 2008 04:52:24 +0000 |
| Subject: | RE: [PHP-DB] display values from to_char() function. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45437@lists.php.net to get a copy of this message | ||
Try
to_char(task_start-(+480/1440),'mm/dd/yy-hh24:mi') as
task_start),to_char(task_end-(+480/1440),'mm/dd/yy-hh24:mi') as task_end
,task_owner,label_phase,to_char(task_actual_start-(+480/1440),'mm/dd/yy-hh24
:mi') as task_actual_start
Jack
-----Original Message-----
From: hridyesh pant [mailto:hridyesh.pant@gmail.com]
Sent: Friday, September 19, 2008 7:23 PM
To: php-db@lists.php.net
Subject: [PHP-DB] display values from to_char() function.
Hi Guys,
i am facing one issue while displaying data.
my sql query is
>>
$res = oci_parse($db,"select
label_name,task_name,task_runnum,task_result,task_machine,task_view,to_char(
task_start-(+480/1440),'mm/dd/yy-hh24:mi'),to_char(task_end-(+480/1440),'mm/
dd/yy-hh24:mi'),task_owner,label_phase,to_char(task_actual_start-(+480/1440)
,'mm/dd/yy-hh24:mi')
from intg_label_hist where label_name ='".$q."' order by task_start DESC");
if (!$res) {
echo("<P>Error performing query: " .
mysql_error() . "</P>");
exit();
}
oci_execute($res);
while ( $row = oci_fetch_array($res) )
{
echo"<TD><font
color=\"#336699\"><b>*$row[TASK_START]*</TD>";
echo"<TD><font
color=\"#336699\"><b>*$row[TASK_END]*</TD>";
echo"<TD><font
color=\"#336699\"><b>$row[LABEL_NAME]</TD>";
echo"<TD><font
color=\"#336699\"><b>$row[TASK_NAME]</TD>";
}
but i am not able to get any value of* $row[TASK_END]* and *$row[TASK_START]
but *rest of the value os coming fine.So i suspect in my select statement
because these two value are like
to_char(task_start-(+480/1440),'mm/dd/yy-hh24:mi'),to_char(task_end-(+480/14
40),'mm/dd/yy-hh24:mi')
in my select statement.
How do i print the values which are coming to_char() function.
Thanks
hp