Ey im just a newbie to php/mysql... i just like to ask a question regarding the sample queries below if i can assign/store a single variable to all of it and how to do it.


Insert Into Mytable1(fname,lname) values('nick','smith')
Insert Into Mytable2(ProdID,ProdName) values('01','PC')
Insert Into Mytable3(ORno,Date) values('01','01/01/01')

please elaborate -- what does "assign/store a variable" mean?

Oh... Im sorry for that... What I really mean is that id like to assign a single php variable and store the 3 queries on it if it is possible...

well, i think i know what you mean

make a string and just concatenate the three query statements but be sure to separate them with semi-colons

if you're going through ODBC there might be a problem but mysql itself has no difficulty running multiple statements (e.g. a mysqldump script)

ok... i already get it... tnx so much... =)