To find an authorized C'est Papier Dealer nearest to you,
please enter your zip code:
// check to see if any dealers were found
if($l_recs_dealers > 0)
{
?>
// display items
$l_col = (0);
$l_cols = (3);
$l_first = (($p_page - 1) * $l_page_size);
// construct sql to retrieve the requested records
$l_sql = ($l_sql." LIMIT ".$l_first.",".$l_page_size);
// retrieve the requested records
$rs_dlr = mysqli_query($g_db_connection, $l_sql);
// process the retrieved records
while($r_dlr = mysqli_fetch_array($rs_dlr))
{
// retrieve the record data
$dlr_pk = stripslashes($r_dlr["pk"]);
$dlr_organization = stripslashes($r_dlr["organization"]);
$dlr_city = stripslashes($r_dlr["city"]);
$dlr_state = stripslashes($r_dlr["state"]);
$dlr_postal = stripslashes($r_dlr["postal"]);
$dlr_phone_1 = stripslashes($r_dlr["phone_1"]);
// check to see if we need to start a new row
if($l_col == $l_cols)
{
// reset column
$l_col = (0);
?>
|
}
// increment column
$l_col++;
?>
|
|
echo($dlr_organization) ?>
echo($dlr_city) ?>, echo($dlr_state) ?> echo($dlr_postal) ?> echo($dlr_country) ?>
phone: echo($dlr_phone_1) ?>
|
|
|
}
// check to see if we need to add empty columns
while($l_col < $l_cols)
{
// increment column
$l_col++;
?>
|
|
}
?>
|
}
// check to see if no dealers were found
else if($p_postal != "")
{
?>
We're Sorry! No dealers were found within 20 miles of the Zip Code you provided.
Click here to request the location of the dealer nearest you.
}
?>