Writing to Existing Table

Mooselyn

This is a simple question, yes I am very new at php but practicing with all my might lol

Recently when writing queries to php I keep running into problems in the line of writing $sql=insert.... Some books I have say to use quotes or single quotes where I find that using them sometimes works sometimes don't. So far this is what I have been able to get done writing NEW input to the database:

$sql="insert into table_customers (company,firstname,surname,email,telephone,fax,address1,town,county,postcode,country,username,password,startdate)

Now my question is, I now want to write a form field where the form writes or updates a specific field in the table. For example, update their firstname and surname with new changes....

How exactly do I do both, call on the table and field then tell it to write??????

Any help is much appreciated 🙂

wilku

Look for some Php/mysql tutorial for details. Here's a quickie 😉 Write a form to choose record you want to change. If you know that, write a form with data from a select query with the record you've chosen. In the script that process data from the form use $POST array to get data from form (or $GET depending on the method you've given in the form). Use update qery to change data in database:

 $sql="UPDATE table_name SET col_name1 = '$value1', col_name2='$value2' WHERE id=$id;";

Hope it helps.

rincewind456

You have to use single or double quotes you can't get any query to work without one or the other, so both of these would work

$sql="INSERT INTO my_table VALUES('name', 'email')";

$sql='INSERT INTO my_table VALUES(\'name\', \'email\')';

but as you can see the first one is easier to read as you don't need to escape the quotes around the insert values.

You use SELECT for reading from a Databse and UPDATE to update a field.

Mooselyn

thanks much for the replies I did finally find what I needed at a forum through a tutorial area, which I discovered the use of insert however the method used in the tutorial flat was not working for me... I did eventually find a code that used what you wrote and it worked like a charm. I did however make an error that took me a half hour to find, simple really, kina dumb, forgot the single quotes around that last line id='id'.......

Again thanks for your inputs!

wilku wrote:
Look for some Php/mysql tutorial for details. Here's a quickie 😉 Write a form to choose record you want to change. If you know that, write a form with data from a select query with the record you've chosen. In the script that process data from the form use $POST array to get data from form (or $GET depending on the method you've given in the form). Use update qery to change data in database:
 $sql="UPDATE table_name SET col_name1 = '$value1', col_name2='$value2' WHERE id=$id;";
Hope it helps.