RE: [PHP-DB] display values from to_char() function.
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:[EMAIL PROTECTED] 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("Error performing query: " . mysql_error() . ""); exit(); } oci_execute($res); while ( $row = oci_fetch_array($res) ) { echo"*$row[TASK_START]*"; echo"*$row[TASK_END]*"; echo"$row[LABEL_NAME]"; echo"$row[TASK_NAME]"; } 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters
Thodoris wrote: I think that the manual is quite clear on this: http://dev.mysql.com/doc/refman/5.1/en/call.html You use a way to query the database like PDO or mysqli and you wite sql. Yes, I've already found that multi-step way before... I was just wondering if anything got better since with regard to this. Apparently not. STF === http://eisenbits.homelinux.net/~stf/ . My PGP key fingerprint is: 9D25 3D89 75F1 DF1D F434 25D7 E87F A1B9 B80F 8062 === -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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("Error performing query: " . mysql_error() . ""); exit(); } oci_execute($res); while ( $row = oci_fetch_array($res) ) { echo"*$row[TASK_START]*"; echo"*$row[TASK_END]*"; echo"$row[LABEL_NAME]"; echo"$row[TASK_NAME]"; } 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/1440),'mm/dd/yy-hh24:mi') in my select statement. How do i print the values which are coming to_char() function. Thanks hp