View Single Post
  #3  
Old 02-11-2004, 07:45 AM
Cheerios
Fire Beetle
 
Join Date: Feb 2004
Posts: 9
Default

SELECT item FROM merchantlist WHERE merchantid = <your_merchant_id>;

That will dump a list of item id's for a given merchantid, and the merchantlist table is where you'll want to add/remove items on your merchants. If that's a pain for you like it is for me give it a little bit and I'll do up a perl script or two to make it a bit easier and post it for download.
Reply With Quote