Updating mysql database with php

The general format of the My SQL query to update a My SQL table is shown below.

So this My SQL code above updates a table named table_name, setting a column name equal to a certain value where a certain column is equal to a value.

The first part of the update script uses the single record selection from last week but adds a little HTML to it to make it more useful.

we need updation in this table as devesh change to dev and his mobile number also need to be changed.

here first we create connection with the database,then database is selected using mysql_select_db(), then update query is passed to the mysql_query( ) and the database table is updated.

This is how the code knows which table in the database we want to update.

After this, we use the SET keyword to set a certain column equal to a certain value where a certain column is equal to a certain value so that we know which row to update.

Leave a Reply

  1. tory belleci kari byron dating 14-May-2020 23:14

    With many adult dating services available, looking for older women has become easier than ever.

  2. Russian girl sport live cam 31-Aug-2020 19:11

    Try to reach multiple endings, scenes and achievements.

  3. updating windows device drivers 25-Oct-2020 04:15

    In addition, there are many great free chat features to take advantage of to make your video chat even more exciting! Once you are done chatting tap the next arrow to be connected in seconds with a new match based on your filter settings.

  4. eminem dating now 11-Nov-2019 10:26

    This website uses cookies to enhance user navigation and to collect statistical data.

  5. Phone livesex 30-Jan-2020 19:24

    Her passionate, creative storytelling spirit has made her a famous journalist, and she is paid a salary of more than ,000 for her work.