*cough* see previous post… dali
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Cochrane Sent: Tuesday, 4 November 2008 18:00 To: [email protected] Subject: [phpug] Re: MySQL question #2 This should do the trick: SELECT p.*, IF(CHAR_LENGTH(i.pic), 'yes', 'no') as hasImage FROM `product` p LEFT JOIN `images` i ON (i.productid = p.productid) hasImage will be 'yes' if there is a row and content in the blob, and 'no' otherwise. HTH - Mike On 3/11/2008 22:40, Michael wrote: Thank you to the people who posted solutions to the last question. :-) To expand on this, is it possible with MySQL to do the following- I have two tables, both with 'productid' as the primary field. I need retrieve a few fields from table 1, but I only need to know if a line exists and has a BLOB size larger then 0, in table 2. (By way of explanation, table 1 has product information and table 2 has product images - both share the same primary field). If that line exists and with content I want to activate code within a PHP 'if' statement, however I don't actually want to retrieve the field. And I'd like to do all of this in 1 SQL statement. Relevant fields within tables- table 1 (product info) - productid (int primary) - title_1 (varchar) - title_2 (varchar) - title_3 (varchar) table 2 (images) - productid (int primary) - pic (blob) -- Mike Cochrane Web Team Leader gardyneHOLT - design partners 18 Beresford Square Newton PO Box 3340 Auckland New Zealand p +64 9 300 3155 f +64 9 302 3349 m 021 545 565 skype gardyneholt_mikec www.gardyneholt.co.nz<http://www.gardyneholt.co.nz> --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
