RE: [PHP] again : database abstraction

Hi Sebastian, Yes, depending on the level of SQL that your ODBC driver supports, this should work. Make sure that the ODBC driver supports full SQL92 syntax. You do need to have ODBC support compiled into PHP for this to be valid though. If you don't have control over the webservers I'm not sure that you have a solution here. Hope this helps. Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Sebastian Stadtlich [mailto:Stadtlich@mediaworx.com] > Sent: Wednesday, November 15, 2000 11:26 AM > To: 'phpmailing' > Subject: [PHP] again : database abstraction > > > Hi > > I need to make a rather complex CMS database independent. ( at > least runable > on MySql and Oracle ) > The problem is that the CMS uses heavy left joins in MySql. ist there > something in php that would > allow me to keep the same syntax for joins for both databases? i 'think' > ODBC would do that, but i'm > not sure what is needed on the serverside that ODBC can be > supported by PHP. > ( we can't access all our clients' > Webservers by telnet and install custon modules ). > any suggestion anyone? > > Sebastian > > _______________________________________________ > > Sebastian Stadtlich > mediaworx berlin AG > > >