[snip] $query = "SELECT DISTINCT q.questions FROM SG_Questions as q, SG_QuesRef as r WHERE r.pos_id = '$pos' AND r.sic_id = '$sic' AND r.cat_id = '$cat' AND r.ques_id = q.ques_id"; $result = mssql_query($query) or die("Can not execute query $query. ");
for ($i = $paging; $i < $paging + $limit; $i++){ $cnt = mssql_data_seek($result, $i); $row = mssql_fetch_array($result); [/snip] What does mssql_num_rows($query) return? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php