SELECT operation using sqlsrv_query in php

Question

I am using following php code to select a max value from a table in MS sql server database. This is just a snapshot of the code and not full code:

$sqlToCheckNID ="Select (?)=max(nid) from testRetailerlist";
$param_nid = array($maxNid,SQLSRV_PARAM_OUT);   
$maxNidInDb = sqlsrv_query($conn,$sqlToCheckNID,$param_nid); 
  echo "<li>" .$maxNid. "<li>";

Its throwing me error as Undefined variable maxNid

I want to echo the value that i get from the select statement. I think I am using the wrong syntax but could not found any example on net.

Try using isset. See this link stackoverflow.com/questions/4261133/… — Adrian
– Adrian, Commented Mar 16, 2013 at 10:33

Adi · Accepted Answer · 2013-03-16 10:49:38Z

1

You need to add your parameters' array as a third argument to sqlsrv_query(). You should also pass the output parameters by reference after initializing them. So your your code would be like this:

$maxNid = 0;
$sqlToCheckNID = "SELECT (?)=MAX(nid) FROM testRetailerlist";
$param_nid = array(&$maxNid, SQLSRV_PARAM_OUT);   
$maxNidInDb = sqlsrv_query($conn, $sqlToCheckNID, $param_nid);
echo "<li>" .$maxNid. "<li>";

For more information please consult the documentation.

edited Mar 16, 2013 at 10:49

answered Mar 16, 2013 at 10:37

Adi

5,1796 gold badges35 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2129794 Over a year ago

ohh i missed that. but am still getting the same error on adding too.m updating the question with the change

Adi Over a year ago

@user2129794, I have modified my answer.

Collectives™ on Stack Overflow

SELECT operation using sqlsrv_query in php

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related