SQL语句分开写 问题

Question

问大家一个弱弱的问题哦.MYSQL语句怎么分开执行啊? 比如如下的
$_result = _query("SELECT 
                      *
                                   FROM
                      tg_workotime
                     WHERE
                      tg_username = IF ('{$_clean['username']}'='',tg_username,'{$_clean['username']}')
                         AND
                      tg_usermember = IF ('{$_clean['usermember']}'='',tg_usermember,'{$_clean['usermember']}')
            AND
                     tg_txtday = IF ('{$_clean['txtday']}'='',tg_txtday,'{$_clean['txtday']}')
             AND
                     tg_localdate >='{$_clean['starttime_start']}'
           AND
              tg_localdate <='{$_clean['endtime_end']}' 
         ORDER BY
  case tg_username
 WHEN
  '小三' then 1
  WHEN
 '小李' then 2
 WHEN
  '小胡'then 3
  end ASC            
    ");怎么把WHERE下面的语句和ORDER BY下面的语句 用变量代替,后再放在SQL语句里,谢谢~~ 

Answer 1

楼主你要干啥。要这么写 "SELECT * FROM WHERE name='" . $name['xx'] . "'"
或"SELECT * FROM WHERE name='$name[xx]'"

Answer 2

我是这样的意思,我想分离开.就如$where里面的一样,里面怎么写啊$where =' 
 tg_username = IF ('{$_clean['username']}'='',tg_username,'{$_clean['username']}')
                         AND
                      tg_usermember = IF ('{$_clean['usermember']}'='',tg_usermember,'{$_clean['usermember']}')
            AND
                     tg_txtday = IF ('{$_clean['txtday']}'='',tg_txtday,'{$_clean['txtday']}')
             AND
                     tg_localdate >='{$_clean['starttime_start']}'
           AND
              tg_localdate <='{$_clean['endtime_end']}'' ;$_result = _query("SELECT 
                      *
                                   FROM
                      tg_workotime
                     WHERE
                           $where
      ORDER BY
         case tg_username
     WHEN
          '小三' then 1
      WHEN
         '小李' then 2
     WHEN
          '小胡'then 3
      end ASC            
    ");