[PHP-DB] Interbase 6.01 (dialect 3), PHP4 and DATE

[Francisco Puentes]

How can I manage DATE fieldtype in PHP4 with Interbase?

The problem is that i manage DATEs in format DDMMYYYY (spain) but Interbase
manage it in MMDDYYYY format; so queries expected data in that format while
i need it in other format.

        <%
          if(isset($action))
            {
             ibase_timefmt("%d/%m/%Y",IBASE_DATE);

$ibh=ibase_pconnect("localhost:/usr/interbase/databases/dbsite.gdb","SYSDBA"
,"masterkey");
             if($action=="edit" && isset($CONTEXT) && isset($DATE))
               {
                $sth=ibase_query($ibh,"SELECT newstext FROM news WHERE
context='$CONTEXT' AND newsdate='$DATE';");
                if(($row=ibase_fetch_row($sth)))
                  {
                  }
               }
            }
         %>

Would you send me examples (small && smart) of that?




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]