Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - PHP ODBC - odbc_num_rows() - Number of Affected Rows

By: FYIcenter.com

(Continued from previous topic...)

PHP ODBC - How To Get the Number of Affected Rows?

If you insert multiple rows with a single INSERT statement, you can use the odbc_num_rows() function to find out how many rows were inserted. odbc_num_rows($result_set) returns the number of affected rows based on the result set object returned by the last INSET, UPDATE or DELETE statement.

The following tutorial script shows you report back the number of rows inserted properly:

  $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter');

  $sql = "INSERT INTO fyi_links"
      . " SELECT id+1000, REVERSE(url), notes, counts, time"
      . " FROM fyi_links WHERE id > 1000";
  $res = odbc_exec($con, $sql);
  if (!$res) {
    print("SQL statement failed with error:\n");
    print(odbc_error($con).": ".odbc_errormsg($con)."\n");
  } else {
    $number_of_rows = odbc_num_rows($res);
    print("$number_of_rows rows inserted.\n");


If you run this script, you should get:

2 rows inserted

(Continued on next topic...)

  1. PHP ODBC - How To Create a New Table?
  2. PHP ODBC - How To Insert Data into an Existing Table?
  3. PHP ODBC - How To Insert Multiple Rows with a subquery?
  4. PHP ODBC - How To Get the Number of Affected Rows?
  5. PHP ODBC - What Is a Result Set Object Returned by odbc_exec()?
  6. PHP ODBC - How To Loop through Returning Rows?
  7. PHP ODBC - How To Update Existing Rows in a Table?
  8. PHP ODBC - How To Delete Existing Rows in a Table?
  9. PHP ODBC - How To Include Text Values in SQL Statements?
  10. PHP ODBC - How To Include Date and Time Values in SQL Statements?
  11. PHP ODBC - How To Display a Past Time in Days, Hours and Minutes?
  12. PHP ODBC - How To Perform Key Word Search in Tables?
  13. PHP ODBC - How To Query Multiple Tables Jointly?
  14. PHP ODBC - How To Create an Identity Column?

Related Articles:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: