error msg for mssql_query()

[Avatar19]

Hi everyone,
I am getting a confusing error message, I have done some googling an can't find a good solution.

My error message is :

Fatal error: Call to undefined function mssql_query() in C:\xampp\htdocs\dbf\database_files\AddUsers1.php on line 24

The code that is generating this error is :

$q1 = mssql_query("INSERT INTO users (name, surname, dob, status) VALUES ('$name', '$surname', '$birthdate', '$status') SELECT
SCOPE_IDENTITY() AS [SCOPE_IDENTITY]");
$r = mssql_fetch_assoc($q1);
 
$insert_id = $r['SCOPE_IDENTITY'];
echo $insert_id;
 
 

I have tried the insert with just mysql_query() and it works great, so there is no problem with the variables or connection.

Also a second question, could someone please provide a explanation as to how SCOPE_IDENTITY() works because Google has not been very helpful in giving me an explanation I can understand clearly.

Thank you for any and all help,
Avatar19

[code green]

Looks like you don't have mssql enabled in the php.ini file.
The statements will be there, They just need un-editing or setting to true,

[Avatar19]

Oh ok cool, thanks a lot I will give it a look when I get home and let you know if it works out.
Thanks code green

Avatar19

[Avatar19]

Hey so perhaps someone can help give me a lil more direction on what I need to do cos I still cannot figure it out.

I am using xampp and my directory looks like this
and I am assuming that the ini file that I need to alter will be in the php folder within xampp.
I think this cos I have looked in most of them and the only ones with ini files are in the php folder.

So in the folder there are 3 files called 'php'.
one is of type 'configuration setting'
one is of type 'INI DEVELOPMENT FILE'
one is of type 'INI PRODUCTION FILE'

I assumed that I should alter the config type file.
I did a word search for mssql and found this:
extension=php_mssql.dll
extension=php_pdo_mssql.dll
as well as a whole subsection titled mssql.
I enabled all of them but the function still doesn't work ??