Code: Select all
SELECT products.product_name, products.description, products.price, uploads.thumb_path FROM products, uploads WHERE 1 AND products.product_name LIKE '%toaster%'Code: Select all
product_name description price thumb_path
Toaster Great toaster, only 300 pieces run through. Mint ... 30 members/steveo31/tools_thumb.jpg
Toaster Great toaster, only 300 pieces run through. Mint ... 30 members/CanadaMan102/toaster_thumb.jpgI'm using WHERE 1 just to get the WHERE out of the way as I am using loops to construct the query.
Thanks