".stripslashes($name)." - ".$city.", ".$dealer_row["StateCode"]."
Demo Program Details - Contact ".$name."

"; return $output2; } require("/var/www/php/db_fns.php"); $demo_program_product_line = stripslashes($_GET["demo_program_product_line"]); if ($demo_program_product_line == "S"){ $title = "Sailboat"; $switch1 = "K"; $switch1title = "Kayak"; $dealertype="W"; } elseif ($demo_program_product_line == "K"){ $title = "Kayak"; $switch1= "S"; $switch1title = "Sailboat"; $dealertype="K"; } else{ $demo_program_product_line = "S"; $title = "Sailboat"; $switch1 = "K"; $switch1title = "Kayak"; } $output = ""; $result = ""; db_connect(); mysql_select_db("www"); $query = "select D.DealerNumber, DL.*, C.Name as country from DealerLocations as DL INNER JOIN Dealers as D on DL.DealerId = D.Id INNER JOIN Countries C on DL.CountryCode = C.CountryCode where DL.IsActive = 1 and D.IsActive = 1 AND DL.LocationTypes LIKE '%R%' AND DL.DemoProgramProductLines like '%$demo_program_product_line%' order by DL.CountryCode desc, DL.StateCode asc"; $result = mysql_query($query); $num_rows = mysql_num_rows($result); $state = ""; $country = ""; for ($i=0; $i<$num_rows; $i++){ $row = mysql_fetch_array($result); if ($row["country"] <> $country) { $output .= "".$row["country"]."

"; $country = $row["country"]; } $output = output_dealer($row, $output, $dealertype, $demo_program_product_line); } if ($num_rows == 0){ $output = "There are currently no $title demo locations."; } */ ?> Hobie Company
Hobie Cat - Home
Contact Hobie

Locate a Dealer

Dealer Product Demonstration Locations
Hobie News
Hobie Awards
 
 
 
 
 
 
 
 
 

Hobie Cat Demo Locations:
$switch1title Demos"; ?>

 

 
     

 

 

 

 

 
Hobie Cat Float Cat Fishing Contact Dealers Hobie Cat - Home