//Try to connect to the DB
$mysql = mysql_connect($host, $user, $password) or die(’Could not connect: ‘.mysql_error());

//Setup the SQL statement
$sql = ‘SELECT SQL_CALC_FOUND_ROWS name, address, city, state, zip FROM users’;

//Run the query
$result = mysql_query($sql, $mysql);

//Get the results as an associative array and put each row into the numerically indexed array
while ($row = mysql_fetch_assoc($myresult))
$results[] = $row;

//Now we get set up the query to get the number of results that were returned
$sql = ‘SELECT FOUND_ROWS() as foundrows’;

//Run the query
$result = mysql_query($sql, $mysql);

//Store the resulting row
$row = mysql_fetch_assoc($result);

//Get the total rows
$total = $row['foundrows'];

//Assign the results to smarty
$smarty->assign(’results’, $results);
$smarty->assign(’total’, $total);

//Display the Smarty template
$smarty->display(’index.tpl’);