How to get the number of affected rows in previous MySQL operation?

SEEKSCRIPTS.COM - OPEN SOURCE, FREE AND COMMERCIAL PHP SCRIPTS FOR YOUR SITE

home page latest news web development curriculum vitae php scripts contact me

• C# (Microsoft .NET)
• JAVA
• Dynamic HTML
• PHP & MySQL
• ASP.NET - C# & VB.NET
• Perl & CGI
• C | C++
• Vector Markup Language
• SMIL
• Assembler
• Databases
• Wap Development
• Web site promotion
• Web Marketing

• Curriculum Vitae (CV)
• Major web solutions
• Web design projects
• Software solutions

How to get the number of affected rows in previous MySQL operation?

Free programming example written by Anton Zamov

You have to use the mysql_affected_rows() function, for example
on delete command, in order to get the numbe rof the delted rows
you need to do the following:

<?php
...
mysql_query("DELETE FROM mytable WHERE ID > 1000 ");
echo "Records deleted: ". mysql_affected_rows();
...
?>

Jobs Portal, poweful jobs board software

PHP Mall, multi vendors mall website software

Car Portal, php script for auto classifieds websites

NetArt Media, software products and services

Real Estate Portal, web software for real estate portals

Blog System, multi user blog hosting script

Classified Ads Script, Responsive & SEO optimized PHP classified ads script for your site

WebSite Directory Script, Create easily your own website directory with this professionally designed script