Get affected rows for an update in php

Code:

<?php
   mysql_connect("server","jdbname","password");
   mysql_select_db("userdb");

   $query = "UPDATE Employee SET salary = '39.99' ";
   $result = mysql_query($query);
   echo "There were ".mysql_affected_rows()." product(s) affected. ";

?>

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : Get affected rows for an update in php
vBulletin update -
update query example -
update an xml file with jaxb -
three rows frameset . -
Update table with search box using ajax -
Asp.net insert update delete Examples -
Select odd rows from table -
update an xml file with jaxb and accessing to its elements -
Update phpbb to latest version with mods -
Number of Rows Returned by query in php -

Topic Tags

PHP Database

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com