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
> 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
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