RE: [PHP-DB] Unsure of how to perform query and results..

2003-11-21 Thread Aaron Wolski
Hi John, Thanks for taking the time to respond. What am I trying to do? Well...I am trying to build a mailing list of previous customers WHO purchased product_id 1 but not product_id 14. I have the product items (id's) stored in the CartTable and I have customer info stored in the OrderTable.

Re: [PHP-DB] Unsure of how to perform query and results..

2003-11-20 Thread CPT John W. Holmes
From: Aaron Wolski [EMAIL PROTECTED] I have data in a Db that looks something like: 14,[EMAIL PROTECTED],Andrew,Smith 1,[EMAIL PROTECTED],Andrew,Smith 14,[EMAIL PROTECTED],Barbara,Richardson 1,[EMAIL PROTECTED],Barbara,Richardson The number represents a product_id that was purchased by