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! Quote 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. Quote 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. Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.