iPixel Posted March 2, 2011 Share Posted March 2, 2011 I run this query in TOAD ( database management application ) and it returns to me the date that a specified table was last updated. $qry = "SELECT to_char(LAST_DDL_TIME, 'MM/DD/YYYY') AS LASTUPDATED FROM all_objects WHERE owner = 'USER' AND object_name = 'TABLENAME'"; $go = oci_parse($conn, $qry); oci_execute($go); $result = oci_fetch_assoc($go) echo = $result['LASTUPDATED']; However when i run that identical query through PHP i get absolutely NOTHING. Any idea if perhaps PHP isnt capable of retreiving such data or if maybe i'm doing something wrong. Thanks! Link to comment https://forums.phpfreaks.com/topic/229371-is-this-a-php-issue/ Share on other sites More sharing options...
PFMaBiSmAd Posted March 2, 2011 Share Posted March 2, 2011 echo = $result['LASTUPDATED']; ^^^ That's invalid php and produces a fatal parse error. Are you developing and debugging your code on a system with error_reporting set to E_ALL and display_errors set to ON in your master php.ini so that all the errors php detects will be reported and displayed? You will save a TON of time. Link to comment https://forums.phpfreaks.com/topic/229371-is-this-a-php-issue/#findComment-1181843 Share on other sites More sharing options...
iPixel Posted March 2, 2011 Author Share Posted March 2, 2011 Yea i'm an idiot i constantly omit using error_reporting. However... i placed this code above it all.. error_reporting(E_ALL); ini_set('display_errors','On'); And the page still comes up blank... no errors reported it seems. Link to comment https://forums.phpfreaks.com/topic/229371-is-this-a-php-issue/#findComment-1181845 Share on other sites More sharing options...
PFMaBiSmAd Posted March 2, 2011 Share Posted March 2, 2011 Are you developing and debugging your code on a system with error_reporting set to E_ALL and display_errors set to ON in your master php.ini so that all the errors php detects will be reported and displayed? You will save a TON of time. Your code never runs when there is a fatal parse error and those two lines of code are never executed. Link to comment https://forums.phpfreaks.com/topic/229371-is-this-a-php-issue/#findComment-1181848 Share on other sites More sharing options...
iPixel Posted March 2, 2011 Author Share Posted March 2, 2011 Wow i'm a blind idiot . Thanks so much! Man i hate those semi-colons. Link to comment https://forums.phpfreaks.com/topic/229371-is-this-a-php-issue/#findComment-1181851 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.