Updating mysql data with php


As you can see below, data is displayed in an HTML table.My SQL UPDATE with WHERE My SQL UPDATE command can be used with WHERE clause to filter (against certain conditions) which rows will be updated.



The procedural style is much similar to old My Sql and it may be helpful to users who are just switching to My Sqli, but should keep away altogether.CREATE DATABASE `dbtuts` ; CREATE TABLE `dbtuts`.`users` ( `user_id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `first_name` VARCHAR( 25 ) NOT NULL , `last_name` VARCHAR( 25 ) NOT NULL , `user_city` VARCHAR( 45 ) NOT NULL ) ENGINE = Inno DB; i hope you should know that how to select data from database , so i come to the point.



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>