Updating database contact
Using this you can then create the update script, which will actually have two sections to it.
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.
So far you have learnt how to put information into your My SQL database, view the information in it and select which information you would like to view.
In this part I will show you how to do the two final actions, updating your database and deleting records from it.
Save and manage messages sent from your Word Press website via Contact Form plugin.
Search, view, delete, download, and re-send messages quickly right from your Word Press admin dashboard.
Instantly pull records for every person who interacts with your organization, and view membership status, event registrations, donations made, and more.
Locate a record by information such as name, organization or email address just by typing in the quick search box.
In by Gary Keller, Jay Papasan & Dave Jenks, it is recommended that agents use a “33 Touch” plan to make 33 different touches to the members of their database to obtain a ratio of 12:2 on the business that they receive in return.Advanced contact database search lets you do exactly these kinds of sophisticated queries.Use multiple search criteria to find the exact information you're looking for.This makes it much more effective for an update script.$query = "UPDATE contacts SET first = '$ud_first', last = '$ud_last', phone = '$ud_phone', mobile = '$ud_mobile', fax = '$ud_fax', email = '$ud_email', web = '$ud_web' WHERE id = '$ud_id'"; This query tells the database to update the contacts table where the ID is the same as the value stored in $ud_id (which as you can see from the form on the previous page was set as the id of the record we are updating) and to set the following fields to the specified values (which were set using the form on the previous page).