Thread: PHP and MSSQL query question

Hi, I am trying to stick a couple of queries in a test page that I have got up and running - but I am unable to  get 1 query to display correctly - I keep getting Resource ID #4 or Array displayed back instead. Code is as follows: $sql1 = "select count(*) from mytable" ; $sql_result1 = mssql_query($sql1,$ connection ); echo "There are currently $sql_result1" ; echo " users logged onto the...

Although this forum is not for the php_mssql php extension, your question would apply to both. You have to fetch the results returned by your query, so you can use the following: http://ca.php.net/manual/en/function.mssql-fetch-array.php http://ca.php.net/manual/en/function.mssql-fetch-row.php http://ca.php.net/manual/en/function.mssql-fetch-object.php First two being the ones you most likely ones you could choose from. Read the php manual...