bogaert-y

thanks hansford, however still does not seem to be working the echo returns nothing. I have hardcoded a contract number in the query where I know it should return a value. Any idea's?

HI guys, I have made a query in oci which works, the result should be a date format as in "2015-10-13" for example, the query can only return 1 "answer" however how can I get the result in a variable? the query is: $start = oci_parse($conn, " SELECT TO_CHAR(MIN(FLT_COM_DEP_BLK),'YYYY-MM-DD') FROM MASTER.FLIGHTS WHERE FLT_LFS_ID=100 AND INSTR(UPPER(FLT_TEXT_AS_SPECIAL),'_CID='||'$contractnr')>0 "); oci_execute($start); I want this result in a variable called $startd. thanks for the help. Yannick