The other day I ran across http://adodb.sourceforge.net/ it seems like a great way to write code that is largely independant of your database.
I was wondering if there are any other similar tools out there? Before I commit to using adodb, I'd like to check out the competition.
plenty of ways of doing it. if your using php5 you can create interfaces that layout rules that implimenting databases must follow. this make it real easy to write your own abstraction layers, that you know will allways work with your code.
But you may as well use PEAR DB or, (in PHP 5.1+) PDO.
They actually ship with PHP and/or are more standard ways of doing it rather than pulling in a third party library.
PDO will ultimately be the best way to do things.
Mark
man... ive never even really looked at PDO. looks real interesting. im recompiling php as we speak as i must have disabled it in my last compile. so glad ive been stuffing around with my cms instead of actually working, because this looks pretty damn cool.