Hi,
I am wondering about the possibility of using a MySQL query and including an if type of statement to use add a portion of command to the existing commands. So that the base query would be "select * from tblman where id>10" and then I would want an if statement to be like such:
if tblman.check is 'yes' then add to the query ' and id<90'
otherwise add ' and id<80'
this is a simplified version of what I want to do, I would like to keep all the queries as minimal in count as possible. Thanks for the help and hope this isn't too confusing.
