sql language variable

[m0119975]

All,

I am still a newbie in SQL and PHP and I want to use a variable for the sql language name.

for example:

for -> mysql_query($query)="......."
i want -> (sqllanguage)_query($query)="......."

so if i change for example from mysql tot mssql i only have to change that var once.

Any idea how to do that?

Maybe is it that simple that i am missing it... but i don't know how.

thx
M0119975

[mrhappiness]

you need an abstraction layer

search for a class that does all the database stuff and internally handles the different types of database

http://pear.php.net/package/DB is a good point to start from

[mtimdog]

I agree with Mr.Happiness

I suggest using an abstraction layer, or writing your own.

(pseudo of course)

function db_query($sql){
return mysql_query($sql);
}