where clause not displaying data

[auchan]

i am trying to display data based on wether data in a field is new. instead of showing only the data that is new it is showing all data. can someone point out my error. many thanks\[code\]<?phpinclude("../../js/JSON.php");$json = new Services_JSON();// Connect to MySQL databasemysql_connect('localhost', 'root', '');mysql_select_db(sample);$page = 1; // The current page$sortname = 'id'; // Sort column$sortorder = 'asc'; // Sort order$qtype = ''; // Search column$query = ''; // Search string$new = 1;// Get posted dataif (isset($_POST['page'])) {$page = mysql_real_escape_string($_POST['page']);}if (isset($_POST['sortname'])) {$sortname = mysql_real_escape_string($_POST['sortname']);}if (isset($_POST['sortorder'])) {$sortorder = mysql_real_escape_string($_POST['sortorder']);}if (isset($_POST['qtype'])) {$qtype = mysql_real_escape_string($_POST['qtype']);}if (isset($_POST['query'])) {$query = mysql_real_escape_string($_POST['query']);}if (isset($_POST['rp'])) {$rp = mysql_real_escape_string($_POST['rp']);}// Setup sort and search SQL using posted data$sortSql = "order by $sortname $sortorder";$searchSql = ($qtype != '' && $query != '') ? "where ".$qtype." LIKE '%".$query."%' AND new = 1" : '';// Get total count of records$sql = "select count(*)from act$searchSql";$result = mysql_query($sql);$row = mysql_fetch_array($result);$total = $row[0];// Setup paging SQL$pageStart = ($page -1)*$rp;$limitSql = "limit $pageStart, $rp";// Return JSON data$data = http://stackoverflow.com/questions/3680749/array();$data['page'] = $page;$data['total'] = $total;$data['rows'] = array();$sql = "select *from act$searchSql $sortSql$limitSql";$results = mysql_query($sql);while ($row = mysql_fetch_assoc($results)) {$data['rows'][] = array('id' => $row['id'],'cell' => array($row['id'], $row['slot'], $row['service'], $row['activity'], $row['department'], $row['company'], $row['address'], $row['user'], $row['item'], $row['filebox'], date('d/m/Y',strtotime($row['date'])), $row['quantity'], $row['type'], $row['new']));}echo $json->encode($data);?>\[/code\]