Insert into 2 tables

[timsharpe]

How do I insert into 2 tables at the same time?

[ednark]

please be more specific...

i think someone can help if give more explaination

• what information do you want to display
• where is this information coming from
• can give a small sample of the html you want it to look like when you are done

keep in mind that php writes html linearly... so you can't write directly to output two tables in differnet places...
you can however write two tables into strings... then later print them out in the correct order

does that make sense?

[dalecosp]

$sql = "select s.id, s.header, from stories s, keywords k where s.id = k.story";

This is a valid SELECT query in MySQL. Have you tried anything similar with INSERT?

[shareaweb]

Yes you should be able to use table aliases as stated to do your inserts in most dbms..

INSERT INTO table1 t1, table2 t2 (t1.column1 , t1.column2 , t2.column1 , t2.column2) VALUES ('AS' , 'SIMPLE', 'AS', 'THAT');