MSSQL on Web

[lucasabbud]

Hi, i'm using Mucore 1.0.8, with ODBC connection.

I'm using a template which has this:

$Sdaaq = mssql_query("SELECT count(*) FROM MEMB_STAT WHERE ConnectStat = '1'");
$online= mssql_result($Sdaaq, 0, 0);
//
$Sdaaq1 = mssql_query("SELECT count(*) FROM Guild");
$guild= mssql_result($Sdaaq1, 0, 0);
//
$Sdaaq2 = mssql_query("SELECT count(*) FROM Character");
$charac = mssql_result($Sdaaq2, 0, 0);
//
$Sdaaq3 = mssql_query("SELECT count(*) FROM MEMB_INFO");
$cues= mssql_result($Sdaaq3, 0, 0);

How do i change it to work with odbc??

Thanks!!

 

[KarLi]

u cant change that on the template, u must use ODBC function in config.ini on mucore to make the website work with ODBC then, why u dont want to use MSSQL ? its faster and better.

 

[lucasabbud]

u cant change that on the template, u must use ODBC function in config.ini on mucore to make the website work with ODBC then, why u dont want to use MSSQL ? its faster and better.

I've SQL Server 2008 R2 Express version, does not have SQL Agent to run job.
How do I run it with mssql?

 

[KarLi]

Maybe u will have to install other SQL Version

 

[fallenfate]

For 2008R2 you can use PHP sqlsrv() drivers and change mssql_query to sqlsrv_query, etc. But you need to download the drivers first.

Sqlsrv drivers download -

You must be registered to see links

You need to add them to your php.ini in order for them to work and then reboot Apache.