你可以看看这个: $where=" WHERE 0=0"; $where.=" AND (title like '%$search_id%' )"; $order=" ORDER BY a DESC"; $MSSQL->Query("SELECT id, kind, title, visited_times, a FROM(SELECT id, kind, title, visited_times, CONVERT(varchar(10), send_datetime, 20) AS a FROM ps_partydata_character UNION all select id, kind, title, visited_times, CONVERT(varchar(20), send_datetime, 20) AS a FROM ps_partydata_video)DERIVEDTBL $where $order");
$where=" WHERE 0=0";
$where.=" AND (title like '%$search_id%' )";
$order=" ORDER BY a DESC";
$MSSQL->Query("SELECT id, kind, title, visited_times, a FROM(SELECT id, kind, title, visited_times, CONVERT(varchar(10), send_datetime, 20) AS a FROM ps_partydata_character UNION all select id, kind, title, visited_times, CONVERT(varchar(20), send_datetime, 20) AS a FROM ps_partydata_video)DERIVEDTBL $where $order");