just starting..simple question

[Anon]

I have a form set up that needs to insert the information into 2 different tables.How do i execute 2 insert commands in the same $sql query.

his is what i have...

$sql = "INSERT INTO students (fname,lname,program,tuition,other,description) VALUES ('$fname','$lname','$program',$tuition,$other,'$description')";

[Anon]

You don't. Just issue two seperate insert statements.

[Anon]

$sql = "INSERT INTO students (fname,lname,program,tuition,other,description) VALUES ('$fname','$lname','$program',$tuition,$other,'$description')";
$sql = "INSERT INTO payments (student,amount,date) VALUES ("hey",$amount,$date)";

is this what you mean because i can't get it to work...

thanks,
chase

[Anon]

execute_sql('some insert statement)
execute_sql('some other insert statement)

You have to actually execute the sql before redeclaring $sql in the code you posted.

[Anon]

i.e

$sql =mysql_query( "INSERT INTO students (fname,lname,program,tuition,other,description) VALUES ('$fname','$lname','$program',$tuition,$other,'$description')");

$sql = mysql_query("INSERT INTO payments (student,amount,date) VALUES ("hey",$amount,$date)");