php mssql

How do you connect to the mssql server? PDO?

do you want to handle mysql with recordet or something like tha ?

hope this helps

http://www.weberdev.com/get_example.php3?ExampleID=3905
http://www.hscripts.com/tutorials/php/mysql-functions/mysql-field-len.php

What version of PHP do you have?  What OS/Webserver?  Which version of MS SQL server?  

Details are important here.  PHP 5.2 and below on Windows can use the php_mssql driver while PHP 5.3 and above can not.  PHP 5.3 and above must use sqlsrv driver for direct access.  With the correct SQL Native Client installed, you can also use ODBC to connect.  PDO driver is available in some variations also.

What code are you using right now?

use adodb.inc.php
http://adodb.sourceforge.net/
you will have similar function to mssql.

@beridius does not seem to be responding so we can't know what's going on with him.

sorry thanks for your post the connection to mssql is mssql_query with mssql_fetch_assoc($data))


I dont use PDO. the PHP version is 5.3.14

here is one of my connections

$data = mssql_query("
SELECT      sum(Transactions) + sum(Duplicates)
FROM [SQL01].[dbo].[KPIDay_T]
WHERE        (iDHClientID = 90) AND (UpdtdWhn BETWEEN CONVERT(DATETIME, '$date1', 102) AND CONVERT(DATETIME, '$date2', 102))");
$row = mssql_fetch_assoc($query);

Select allOpen in new window

Thanks Ray I checked my Code and you was right I was using a array thanks so much