MS SQL Query problem

[mhoward]

I am trying to do the following query on my database table...

$ReferenceQuery = mssql_query("SELECT MAX (CallID) FROM $CallLog") + 1;

The problem is that the value of $ReferenceQuery equals 4???

There are over 26000 records in the database and when I run the same query on the SQL Server itself, the value given is 00026410.

Why is my PHP query not working? I expected the value of $ReferenceQuery to be 00026411.

Any ideas?

[mhoward]

Sorted!

MS SQL gives a resource ID# rather than an integer on SELECT statements, so all I had to do was turn the result into an integer and + 1.

Easy!

[Christoph09]

If callID is just an incremented number, you could have just done a mysql_num_rows and added 1.

[tomhath]

If callID is just an incremented number, you could have just done a mysql_num_rows and added 1.

Wow, that's the most offbase answer I've seen in a while.

First of all, he was asking about MS SQL Server, not mysql.

Second, the number of rows would always be 1 since it was calling a row aggregate function; the number rows has nothing to do with the value that would've been returned as MAX(CallID).

[mhoward]

Also, with over 26000 records in the database, the mssql_num_rows may take a while to execute which would cause me even more problems.

Thanks for the response though 🙂

[jerdo]

You couldn't use mysql_num_rows, you're using MSSQL

[Christoph09]

Ohhhh . . . I didn't see that. That must be the Microsoft crap . . .

In my defense though, (if you were using MySQL) you could just say SELECT * FROM table, and then do a num rows on it.

Cheers! 🙂