Saving data to a different table |
8/5/2008 10:44:22 AM |
PHPRunner General questions | |
author
Help again, //** Save new data in another table **** global $conn,$strTableName; $strSQLSave = "INSERT INTO events1 (Code,Price) values ("; $strSQLSave .= $values["Code"].","; $strSQLSave .= $values["Individual_Amount"]; $strSQLSave .= ")"; db_exec($strSQLSave,$conn); return true; // return true if you like to proceed with adding new record
|
|
J
|
Jane 8/6/2008 |
Hi, insert into TableName (NumberField, TextField, DateField) values (1,'some text','2008-08-06') $strSQLSave = "INSERT INTO events1 (Code,Price) values ('"; $strSQLSave .= $values["Code"]."',"; $strSQLSave .= $values["Individual_Amount"]; $strSQLSave .= ")"; |