table 1: item item_id item_name item_price item_description
table 2:item_photo item_id item_photo_id item_photo
Because I want to able to insert multiple photos as once, can you have a mysql_query() insert multiple tables at once?
If you use the more modern [man]MySQLi[/man] extension instead of the outdated MySQL extension, you can write multiple SQL statements in a single command. Otherwise there is nothing stopping you using two commands.
Thank you so much. I do have that.
