|
| |
Featured Lodging
|
Editors Picks
\n";
$metaKeywords= "\n";
$script_name = basename(__file__);
if ( ! isset($directory_hq_config) ) require '../includes/config.directory.hq.inc.php';
if ( empty($page_title) ) $page_title = 'Directory HQ';
ini_set( 'include_path', rtrim(@current(file('include_path.txt'))) );
require_once '../includes/utilities.inc.php'; // debug utilities
// Make a connection to the database named $db
require_once '../includes/directoryhq_params.inc.php';
require_once '../includes/directoryhq_database.inc.php';
require '../includes/lineListings.pagination.inc.php'; //Pagination
error_reporting(E_ALL); // Show ALL Errors
/*
########################
Connect & Query
########################
*/
$connection = mysql_connect("localhost", "cacoast_admin", "letmein");
$db = mysql_select_db("cacoast_directoryhq", $connection);
$sql = '
SELECT
*
FROM
customer_tbl
WHERE
customer_tbl.category_id = 1
AND
customer_tbl.CommunityTableId = 1
AND
customer_tbl.lodging_type_id = 2
OR
customer_tbl.lodging_type_id = 3
OR
customer_tbl.lodging_type_id = 5
ORDER BY
customer_tbl.PaidListing DESC, customer_tbl.AdTitle ASC';
//
$alternate = "2"; // Rows Background Color Alternation :: Number of alternating rows
// Call function with handler. You should only need to change the connection link name, $sql and maybe the search page.
$HQ_Code = SearchNavigation("connection", $sql, $PHP_SELF, $recordsPerPage, $currentPosition);
?>
|
|
Website Design by: