SQL语句分开写 问题

问大家一个弱弱的问题哦.MYSQL语句怎么分开执行啊? 比如如下的

PHP code

$_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语句里,谢谢~~ 

弄2个字符串一拼接，然后放到对应的位置就可以了

能不能帮忙弄一下,中间的符号弄晕我了,谢谢

楼主你要干啥。

要这么写 "SELECT * FROM WHERE name='" . $name['xx'] . "'"
或

"SELECT * FROM WHERE name='$name[xx]'"

我是这样的意思,我想分离开.就如$where里面的一样,里面怎么写啊
PHP code

$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            
    ");