'; $i = 0; echo 'var type=[];'; foreach($category_array as $key => $value) { echo 'type['. $i. '] = '. '["'. $key. '",'. '"'. $value. '"];'; $i++; } echo ''; return; } function create_js_boat_array($boat_array) { echo ''; return; } function create_js_truck_array($truck_array) { echo ''; return; } function create_js_rod_array($rod_array) { echo ''; return; } function create_js_trolling_array($trolling_array) { echo ''; return; } function create_js_outboard_array($outboard_array) { echo ''; return; } /* $path = '/home/users/web/b2037/ipw.panamacitybassmasters/public_html/cgi-bin'; set_include_path(get_include_path() . PATH_SEPARATOR . $path); */ ##include('cgi-bin/pcbmdbinfo.inc.php'); mysql_select_db('panamaci_pcbm') or die('Could not select database'); // Performing category SQL query $query = "SELECT category, catdesc FROM category ORDER by category"; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); while ($row = mysql_fetch_assoc($result)) { $category_array[$row[category]] = $row[catdesc]; } echo create_js_type_array($category_array); // Free resultset mysql_free_result($result); // Performing manufacturer SQL query $query = "SELECT manufacturer_id, type, shtname FROM manufacturer ORDER BY type,shtname"; $result = mysql_query($query) or die('manufacturer Query failed: ' . mysql_error()); while ($row = mysql_fetch_assoc($result)) {# 5 if ($row[type] == 1) { $boat_array[$row[manufacturer_id]] = $row[shtname]; } else {# 4 if ($row[type] == 2) { $truck_array[$row[manufacturer_id]] = $row[shtname]; } else {# 3 if ($row[type] == 3) { $rod_array[$row[manufacturer_id]] = $row[shtname]; } else {# 2 if ($row[type] == 4) { $trolling_array[$row[manufacturer_id]] = $row[shtname]; } else {# 1 if ($row[type] == 5) { $outboard_array[$row[manufacturer_id]] = $row[shtname]; } else { } }# 1 }# 2 }# 3 }# 4 $manuf_array[$row[manufacturer_id]] = $row[shtname]; }# 5 echo create_js_boat_array($boat_array); echo create_js_truck_array($truck_array); echo create_js_rod_array($rod_array); echo create_js_trolling_array($trolling_array); echo create_js_outboard_array($outboard_array); // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?>
Items For Sale
 
It's free to browse our For Sale webpage and it is also free to add your item For Sale.
You may view PanamaCityBassmasters.com items for sale by selecting an item and manufacturer and then click the Search button. If you have a boat, truck, rod and reels, trolling motor or outboard you are wanting to sell add it to our
For Sale webpage for free.
   
Add Item For Sale
   
Search Items For Sale
Item Manufacturer
   
 
 

 

 

Hit Counter
Visitors since October 28, 2007