Queries

[Anon]

Hi there,
Are you able to submit two queries at the same time? Would the script below be correct?
If not, what modifications do i need to make.

$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')";

  $query1 = "UPDATE reply SET replies=replies+1 WHERE topic_id='$id'");

[Anon]

Why would you need to do these queries at the same time. Is one right behind the other OK? If so, I don't see any problems with what you've supplied so far.

Later on,
Big Din K.R.

[Anon]

It still does not work.
I get this error:

Parse error: parse error in c:\phpdev\www\add_new_reply.php on line 41

Line 41 is: $query1 = "UPDATE reply SET replies=replies+1 WHERE topic_id='$id'");

Any ideas?

[gljaber]

No need to close bracket at the end of the line, you haven't got a start one 😉

glj

[fitzbean]

And on a sidenote, that's a parse error .. nothing to do with "2 mysql calls at once". Further more, you are only assigning the query to a variable at that point in the code, not actually making the call.

[Anon]

Thanx for the backup Fltzbean! Thats the same thing I thought when I read his response.

Now on to you les, it's important to realize what the php engine is telling you when it kicks out errors as such. As Fltzbean stated, it's a parse error and therefore has nothing to do with the logic of the program. Something to remember is that you script or program may have no parse errors but still not behave as you wish as a result of some logic issue. The php engine is not going to attempt debugging your logic.

Keep at it,
Big Din K.R.