note 71783 added to function.mssql-num-rows

From: Date: Fri, 15 Dec 2006 15:45:30 +0000
Subject: note 71783 added to function.mssql-num-rows
Groups: php.notes 
Request: Send a blank email to php-notes+get-120638@lists.php.net to get a copy of this message
When connecting to MS SQL, I think it is not right to try mssql_num_rows() or mssql_free_result() on a DELETE Query. Because there is nothing to return. $db = mssql_connect('server','user','password') or die('No Connection'); mssql_select_db('database',$db); $rs2 = mssql_query('DELETE from table',$db); $p = mssql_num_rows($rs2); mssql_free_result($rs2); You might receive a warning like: Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource ---- Server IP: 66.163.161.117 Probable Submitter: 66.98.37.166 (proxied: 1.0 HAVP, 1.1 ipcop.localdomain:800 (squid/2.5.STABLE14)) ---- Manual Page -- http://www.php.net/manual/en/function.mssql-num-rows.php Edit -- https://master.php.net/note/edit/71783 Del: integrated -- https://master.php.net/note/delete/71783/integrated Del: useless -- https://master.php.net/note/delete/71783/useless Del: bad code -- https://master.php.net/note/delete/71783/bad+code Del: spam -- https://master.php.net/note/delete/71783/spam Del: non-english -- https://master.php.net/note/delete/71783/non-english Del: in docs -- https://master.php.net/note/delete/71783/in+docs Del: other reasons-- https://master.php.net/note/delete/71783 Reject -- https://master.php.net/note/reject/71783 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#120638) next »