mysql or mysqli ?

[arkadia2006]

In the config php i have this option :

// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
$config['Database']['dbtype'] = 'mysql';

What is the difference between mysql and mysqli??

thank you
stephane
http://www.arkadia.com

[Floris]

if you have no problem running the forum i don't recommend to run with mysqli.

The mysqli extension allows you to access the functionality provided by MySQL 4.1 and above. More information about the MySQL Database server can be found at http://www.mysql.com/

[arkadia2006]

Thanks Floris !

i will take your advice and stay in msql and not use mysqli ... i m just curious about what kind of problem i can have to swith to mysqli ?

thank you
stephane
http://www.arkadia.com (http://www.arkadia.com/)

[arkadia2006]

if you have no problem running the forum i don't recommend to run with mysqli.

I read the Vbulletin manual and i read (http://www.vbulletin.com/docs/html/install) :

MySQLi is an improved database layer for PHP 5 and MySQL 4.1+. It is strongly recommended that MySQLi be used if your MySQL server is at version 4.1 or higher !

Are you sure that it's better to run in mysql instead of mysqli ?

thank you
stephane
http://www.arkadia.com (http://www.arkadia.com/)

[JJLenz]

I read the Vbulletin manual and i read (http://www.vbulletin.com/docs/html/install) :

MySQLi is an improved database layer for PHP 5 and MySQL 4.1+. It is strongly recommended that MySQLi be used if your MySQL server is at version 4.1 or higher !

Are you sure that it's better to run in mysql instead of mysqli ?
That's the same question I had. The advice being given in the manual is the exact opposite of the advice given here.

I tried to run with mysqli and got an error, so I went to see if I had the proper .dll for mysqli. Php 4.4.4 on Windows tells me that there's no mysqli.dll OR mysql.dll - that mysql support is built in to php - so mysqli may not even be a valid option.

[Colin F]

MySQLi has caused problems in the past. Generally it's a good idea to use it if possible, but if not or if you get errors with it then it doesn't matter if you use mysql either.