Posted 08 May 2006 - 03:10 AM
The new values that will be assigned to these table are done through $_POST function. So do I also have to assign these to normal php variables embedded in the page and then map these to fields in the table?
Posted 08 May 2006 - 03:35 AM
<?php $var_1 = $_POST['textfield_name']; $sql = mysql_query("INSERT INTO table_name VALUES ('$var_1')"); // the same would apply to UPDATE statements // or $sql = mysql_query("INSERT INTO table_name VALUES ('" . $_POST['textfield_name'] . "')"); ?>
edited my errors.
Posted 08 May 2006 - 03:41 AM
INSERT INTO tbl (fld1,fld2) VALUES ('val1','val2');Or to update...
UPDATE tbl SET fld1='val1',fld2='val2';
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users