Update multiple tables with just one que

[Anon]

Can anyone show me how to post data from a form (1) to update multiple tables and (2) with just one query?

[Anon]

it would really help if you said what database you were using.

[Anon]

I use mySQL 3.23.43

[Anon]

This function is still not supported by MySQL.

http://www.mysql.com/doc/T/O/TODO_future.html

1.8.2 Things That Must be Done in the Real Near Future

Atomic multi-table updates, eg
update items,month set items.price=month.price where items.id=month.id;;