I have a quick newbee question:
Is is possible to update in multiple tables at the same time.
I am working with PHP scripts and will use the following example to
explain what I want to do:
I have a generic_user tables, which forms a INNER JOIN with the
logon_user table (with a join using id).
generic_user:
- id
- name
- passowrd
logon_user:
- id
- last_logon
- nickname
As I load all the fields at once in an array, and want to update the
same, so just something like
"UPDATE generic_user INNER JOIN logon_user USING (id) SET name='test',
nickname='test2' WHERE id = 1";
Is there anybody who can explain how to do this?
Thanks in advance,
Regards,
Luuk