Change existing rows in MySQL using UPDATE
69 views

How to Change existing rows in MySQL using UPDATE with the help of PHP??

  1.  <?
  2. mysql_connect(‘localhost’);
  3. mysql_select_db(‘foo’);
  4. $result = mysql_query(
  5. "update users set email = ‘babycarl@lerdorf.com’
  6. where id = ‘carl’");
  7. if($result) {
  8. echo mysql_affected_rows();
  9. } else {
  10. echo mysql_error();
  11. }
  12. ?>



« Using DATE_FORMAT in MySQL Application can be swithed off in IE8 »
Posted on Monday, March 9th, 2009 at 4:44 pm under Basic of MySQL | RSS 2.0 Feed

One Response to “Change existing rows in MySQL using UPDATE”

  1. Index - MySQL basic Says:
    March 9th, 2009 at 5:43 pm

    [...] Using UPDATE in MySQL « Data about pesidential helicopter leaked by Pear 2 pear Posted on Monday, March [...]


Post Comment

You must be logged in to post a comment.


ComputerEducationWorld.com All Rights Reserved © RSS | CBSE | Education Boards Of India | What is My IP?