how to send info to database (noob at this)

[rallokkcaz]

im wondering how to submit info into a database.

 

i know the code goes something lie

$sql = "UPDATE <tablename> set $var = "var"

 

but i know that is wrong

and i want to put it in form so on submit it posts it in the database

 

any help?

 

Thanks.

[Anzeo]

UPDATE is used for editting already existing data in your table.

 

When your creating a new record you need to use this

 

$sql = "INSERT INTO tablename (Columnname1,Columnname2,...)"."VALUES ('$value1', '$value2', ...)";

 

Regards,

Anzeo

[Mr. R]

thats when you want to update a field that already has something in.. you want somehting like..

 

$sql = "INSERT into $table VALUES ('blah', 'blah')";

[Mr. R]

lol beat me to it

[rallokkcaz]

i want to update fields not make a new one. and how exactly would i put that in form?

 

edit:

wait, am i looking at this wrong

??

i think i am

 

[SkyRanger]

There are alot of excellent tutorials on php mysql.  Do a search on google for php mysql tutorial and it will bring up tons.  There are also tutorials on the front page of phpfreaks.  That is how I learned how to do alot of my php/mysql.

 

for update you would need something like

"update table_name set name='$name', name2='name2', etcifmore where id='$id'"