Re: [PHP-DB] Multiple inserts into a database

2006-12-03 Thread Chris
Daniel Smith wrote: select itemname from deals d, items i, deal_items di where d.dealid=di.dealid and i.itemid = di.itemid and dealname="meal 1"; Would I be correct in thinking that the above is in effect the same as: select itemname from deals, items, deal_items where deals.dealid=deal_items

Re: [PHP-DB] Multiple inserts into a database

2006-12-01 Thread Daniel Smith
> select itemname from deals d, items i, deal_items di where > d.dealid=di.dealid and i.itemid = di.itemid and dealname="meal 1"; Would I be correct in thinking that the above is in effect the same as: select itemname from deals, items, deal_items where deals.dealid=deal_items.dealid and item

Re: [PHP-DB] Multiple inserts into a database

2006-11-30 Thread Chris
Daniel Smith wrote: The kind of thing I'm looking to do is to insert a variable number of records into a database as a consequence of a form entry. I am using PHP with a MySQL database to store information that is vaguely analogous to a fast food online ordering system. I have a table containing