Mysql updating a table from another table
Although all the database administrative options can be done through PHP scripts, I strongly suggest installing a copy of PHPMy Admin on your server.It is an excellent free set of scripts that will provide you with an administrative interface for your My SQL database(s).
and save it as Now upload this to your webspace and go to i t in your browser.
If you have PHP installed you will see a huge page with all the details of your PHP installation on it. If you find a section about My SQL then you will know that My SQL is installed.
For many people, the main reson for learning a scripting language like PHP is because of the interaction with databases it can offer.
In this tutorial I will show you how to use PHP and the My SQL database to store information on the web and include it into your website.
It will allow you to store names with their addresses, e-mail and phone numbers.
You will be able to update records and search the database.To do this I will be using an example all the way through.As you use this tutorial, you will learn how to create a web based contact management program.Before you read this tutorial you should have at least a basic knowledge of how to use PHP.If you do not yet know PHP, I suggest that you read our PHP tutorial before continuing.Last week I explained how to create a link for each record to point to your update script.