Page 1 of 1

2 tables in one action

Posted: Tue Mar 01, 2005 3:18 am
by pleigh
is it possible for me to record in two tables in one clicking?for example, i would like to record from php a message in the comments table, but would like to record the date of recording it to another table....is it possible??

Posted: Tue Mar 01, 2005 3:26 am
by Jim_Bo
Hi,

Just insert

$sql = mysql_query ...

for each table .. maybe .. ?

Posted: Tue Mar 01, 2005 3:59 am
by n00b Saibot
ya! definitely! only this to do is to fire the correct SQL for both things.

Posted: Tue Mar 01, 2005 4:07 am
by pleigh
yup, thanks guys, got it right awhile ago... :wink: