id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
90	MySQL 5+ issue: mysql_* vs. mysqli_*	dartar	unassigned	"MySQL 5+ isn't supported as it requires PHP to use the mysqli extension instead of plain old mysql. I hoped there would be a single file to change this, but there seems to be no database abstraction in this project at all.

-- DavidCarrington

I do not have access to a MySQL 5 server for testing. And judging by the feedback that I see here on Wikka, most other Wikka admins are using older versions of MySQL.  However, I do like progress, so I looked at the documentation for the mysqli extension.  I don't see any major issue here.  It looks like the function calls are the same, they just have a different name.  Instead of calling mysql_connect, you call mysqli_connect.  Instead of calling mysql_query, you call mysqli_query.  So on and so forth.

It seems that we would just have to do a simple version check and call ""mysql"" functions for older versions, and ""mysqli"" functions for newer versions.
Please correct me if I'm missing something.  -- JsnX 26 Nov 2004

I'm running MySQL 5 fine with the mysql_* functions.  When you compile PHP, it's your choice to compile the mysql_* or mysqli_* functions.  I chose to compile it with mysql_*, which is working fine for me.  --BarkerJr

Related tickets: #171
"	defect	closed	normal	1.3.3	core	1.1.6.1	normal	invalid	database