In message <[EMAIL PROTECTED]>, Jeromie Clark <[EMAIL PROTECTED]> writes >Yeah, that query doesn't make any sense to me either. >If you told me what you're trying to do, I can probably put you on the >right path.
>IF project = '' THEN v_salesdetails.salesname > ELSE v_salesdetails.projectname AS salesname >END IF, His query says: If the project field is blank, then return the salesname field as salesname If the project field is not blank, then return the projectname as salesname >There's lots of good stuff in the manual, and a ton of SQL primers in >the archive. >http://dev.mysql.com/doc/mysql/en/select.html You are missing it: http://dev.mysql.com/doc/mysql/en/control-flow-functions.html -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
