txgolfer
Posts: 1
|
| Posted: 07/26/2004, 4:43 AM |
|
Problem: I need to update to tables. I need to understand the code structure & components.
I have a "User Registration form" (table #1user creates login record) and then this information needs to create a record (after submitting), into a different table "Property Ad Page" (table #2). I have tried to understand & use the CCS Example of updating two tables, but no luck.
Here is my custom code:
//Custom Code @16-DBD5F1C1
// -------------------------
global $prop_login;
// Write your own code here.
function Tasks_ds_AfterExecuteUpdate() {
$db = new clsDBConnection1();
$SQL = "INSERT INTO property_list (owner_login_password,owner_first_name,owner_last_name) ".
"VALUES (". $db->ToSQL(CCGetFromGet("ad_user_login","user_first_name","user_last_name",0),ccsInteger) .",". $db->ToSQL(CCGetUserID(),ccsInteger) .")";
$db->query($SQL);
$db->close();
}
// -------------------------
//End Custom Code
I don't understand how to code this part:
"VALUES (". $db->ToSQL(CCGetFromGet("task_id",0),ccsInteger) .",". $db->ToSQL(CCGetUserID(),ccsInteger) .")";
What is the format/layout/structure?
Thank you all in advance!
|
 |
 |
|
