Mixing Update and INSERT in an SQL...

[Anon]

is this possible?

E.G.
$sql = "UPDATE firsttable SET groovy_id='$groovey_id', sessionID='$sessionID', super_two='$super_two'WHERE sessionID='$sessionID'";

AND
$sql= "INSERT INTO secondtable VALUES (\"$super_groovey_id\", \"$sessionID\", \"$super_one\"")

Can I amalgamate these into one?

[Anon]

No. What's the problem of having 2 queries?

Diego

[Anon]

none! i was just trying to be more efficient and thought there had to be a better way.

Thanks for the input however.