PHP Insert and update from the same form ?

shortone · 3 Dec 2008 at 19:29

Hi Guys,

I have a table that is updated by a form on a daily basis. I would also like this data to be inserted as a new row in another table at the same time. Any ideas on how I should go about doing this ?

Cheers

Shorty

Russinating · 3 Dec 2008 at 19:36

I don't quite understand. Can't you just... insert the data into a new row in another table?

More details required!

fishfishfish · 3 Dec 2008 at 19:43

If you already have the form's action set up to run a MySQL UPDATE statement, then you simply need to add an additional MySQL statement beneath that to INSERT the data in the other table. Or am I misunderstanding?

shortone · 3 Dec 2008 at 20:11

f you already have the form's action set up to run a MySQL UPDATE statement, then you simply need to add an additional MySQL statement beneath that to INSERT the data in the other table. Or am I misunderstanding?

Nope was me misunderstanding, I am still finding my feet with PHP and MYSQL :-)

I have done as you said and all is working Thanks !!

aftershxck · 3 Dec 2008 at 22:03

Make sure you're preparing your queries so someone can't inject more sql into your query