> if ($currentPage > 1) { > $host="localhost"; > $DB="testDB"; > $user="sa"; > $pass="";
Umm... if that's the only place you use these values, why not specify them inline? Easier to read, for sure. > $connect = mssql_connect($host,$user,$pass) or die ($host." not > accessible."); > if ($DB) mssql_select_db($DB)or die('USE '.$DB.' failed!'); > $query = "SELECT first_name, last_name FROM individual WHERE last_name > LIKE '$searchField%' ORDER by last_name ASC"; Surely LIMIT would be a better way to do this? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php