Insert/Update question

[Anon]

Hi,
Is it possible to do the following:

$query = "insert into reply(post_id, reply_name, reply_email, reply_topic_name, reply_post, reply_time_stamp, autorespond)
values('$post_id','$reply_name','$reply_email','$reply_topic_name','$reply_post','$reply_time_stamp','$autorespond')";

  $query = "UPDATE posts SET last_post='$last_post'";

I'm wanting to insert data into one table and and update another.
Any ideas?
Cheers,
micmac

[stuartc1]

Yes,

after you have specified the value of the first $query you must execute it before specifing the second $query. Either that or give them different names then execute them.

example:

$query1 = "INSERT ....";
$query2 = "UPDATE ....";

$rec1 = mysql_query($query1,$db);
$rec2 = mysql_query($query2,$db);