'.$sql_right.'
'.mysql_error()); $row=mysql_fetch_array($result_right); $right="

".stripslashes($row['title'])."

".stripslashes(nl2br($row['content'])).""; unset($sql_right,$result_right); //  |  Fees Schedule $nav_menu="
  Home   |  Fees Schedule   |  Usefull links   |  F.A.Q.'s   |  About OnlineCranes   |  Contact   |  User agreement   |  Privacy policy
"; $sellrent_link="Sell or Rent
Cranes
"; $finance_link="Crane
Finance
"; $insurance_link="Crane
Insurance
"; $transport_link="Crane
Transport
"; $parts_link="Crane
Parts
"; $repair_link="Crane
Repair
"; $register_link="Register"; $login_link="Login"; //

// //

"; $topmenu="
".$sellrent_link." ".$finance_link." ".$insurance_link." ".$transport_link." ".$parts_link." ".$repair_link." ".$register_link." ".$login_link."
"; if(isset($_SESSION['idle'])) { $log_link="Your were automatically logged out!"; unset($_SESSION['idle']); } if ((isset($_SESSION['enc_client_id'])) && (isset($_SESSION['logged_str']))) { $log_link=" ".$_SESSION['client']." logged in | Logout "; $sellrent_link="Sell or Rent
Cranes
"; $cranes_link="My Cranes"; $profile_link="My Profile"; $log_link="".$_SESSION['client']." logged in | Logout"; $topmenu="
".$sellrent_link." ".$finance_link." ".$insurance_link." ".$transport_link." ".$parts_link." ".$repair_link." ".$cranes_link." ".$profile_link."
"; } ?>[Refresh] $rand_sel=array(); $sql="SELECT DISTINCT manufacturer FROM stock WHERE active='1' AND img0!=\"\" ORDER BY RAND() LIMIT 0,8"; $result=mysql_query($sql, $connection) or die ($sql."
".mysql_error()); while ($row=mysql_fetch_array($result)) { array_push($rand_sel, $row['manufacturer']); } //print_r($rand_sel); exit; foreach($rand_sel as $manufacturer) { $sql="SELECT unid, manufacturer_name, model_name, img0 FROM stock WHERE ". "manufacturer=\"".$manufacturer."\" AND active='1' AND img0!=\"\" ORDER BY RAND() LIMIT 1"; $result=mysql_query($sql, $connection) or die ($sql."
".mysql_error()); $row=mysql_fetch_array($result); $displ_img="\"\""; $unid=$row['unid']; $d_random_picks.="". "". "
".$displ_img."
". $row['manufacturer_name']." ".$row['model_name']."
"; unset($unid); } $_SESSION['rnd_selection']=$d_random_picks; unset($row,$result,$sql,$d_random_picks,$rand_sel); ?>type: $type"; exit; //$spec_link="Special:"; $mfter_link="Crane:          "; $model_link="Model:"; $type_link="Type:"; $cap_link="Capacity:"; $price_link="Price:"; $yom_link="Yom:"; if ($got['ord']=="mfterAsc") { $order="manufacturer_name ASC"; $mfter_link="Crane:          "; } if ($got['ord']=="mfterDesc") { $order="manufacturer_name DESC"; $mfter_link="Crane:          "; } if ($got['ord']=="modelAsc") { $order="model_name ASC"; $model_link="Model:"; } if ($got['ord']=="modelDesc") { $order="model_name DESC"; $model_link="Model:"; } if ($got['ord']=="typeAsc") { $order="type ASC"; $type_link="Type:"; } if ($got['ord']=="typeDesc") { $order="type DESC"; $type_link="Type:"; } if ($got['ord']=="priceAsc") { $order="price ASC"; $price_link="Price:"; } if ($got['ord']=="priceDesc") { $order="price DESC"; $price_link="Price:"; } if ($got['ord']=="capAsc") { $order="tonnage ASC"; $cap_link="Capacity:"; } if ($got['ord']=="capDesc") { $order="tonnage DESC"; $cap_link="Capacity:"; } if ($got['ord']=="yomAsc") { $order="yom ASC"; $yom_link="Yom:"; } if ($got['ord']=="yomDesc") { $order="yom DESC"; $yom_link="Yom:"; } $sql="SELECT unid, special, manufacturer, model, type, tonnage, unit_currency, unit_weights, yom, price, no_price FROM stock WHERE active=\"1\" "; if ($search==1) { // TYPE if (!isset($order)) { $order=" tonnage ASC"; } $sql.="AND type=\"".$s_type."\" ORDER BY ".$order.""; $sql_type="SELECT type FROM types WHERE type_id=\"".$s_type."\""; $result_type=mysql_query($sql_type, $connection); $row_type=mysql_fetch_array($result_type); $ttl_type=$row_type['type']." "; $displ_query="

".$row_type['type']." cranes

"; $searchstring=$row_type['type']." cranes"; } if ($search==2) { // BRAND if (!isset($order)) { $order=" model ASC"; } $sql.="AND manufacturer=\"".$s_brand."\" ORDER BY ".$order.""; $sql_mfter="SELECT naam FROM mfter WHERE mfter_id=\"".$s_brand."\""; $result_mfter=mysql_query($sql_mfter, $connection); $row_mfter=mysql_fetch_array($result_mfter); $ttl_brand=$row_mfter['naam']." "; $displ_query="

".$row_mfter['naam']." cranes

"; $searchstring=$row_mfter['naam']." cranes"; unset($mfter_link); } if ($search==3) { // CAPACITY if (!isset($order)) { $order=" manufacturer_name ASC"; } $sql_cap="AND tonnage>=\"$query_tons_min\" AND tonnage<=\"$query_tons_max\" ORDER BY ".$order.""; $plus=$s_capacity+50; $displ_capacity="".$s_capacity." - $plus"; if ($s_capacity==800) { $displ_capacity="over 800"; $sql_cap="AND tonnage >= \"$query_tons_min\" ORDER BY special DESC "; } $sql.=$sql_cap; $displ_query="

".$displ_capacity." ton cranes

"; $searchstring=$displ_capacity." ton cranes"; $ttl_capacity=$displ_capacity." ton "; } if ($search==4) { // TYPE + CAPACITY if (!isset($order)) { $order=" tonnage ASC"; } $sql.="AND type=\"".$s_type."\" AND tonnage>=\"$query_tons_min\" AND tonnage<=\"$query_tons_max\" ORDER BY ".$order.""; $sql_type="SELECT type FROM types WHERE type_id=\"".$s_type."\""; $result_type=mysql_query($sql_type, $connection); $row_type=mysql_fetch_array($result_type); $plus=$s_capacity+50; $displ_capacity="".$s_capacity." - ".$plus; if ($capacity==800) { $displ_capacity="over 800"; } $displ_query="

".$displ_capacity." ton ".$row_type['type']." cranes

"; $searchstring=$displ_capacity." ton ".$row_type['type']." cranes"; $ttl_capacity=$displ_capacity." ton "; $ttl_type=$row_type['type']." "; } if ($search==5) { // TYPE + BRAND if (!isset($order)) { $order=" model_name ASC"; } $sql.="AND type=\"".$s_type."\" AND manufacturer=\"".$s_brand."\" ORDER BY ".$order.""; $sql_type="SELECT type FROM types WHERE type_id=\"".$s_type."\""; $result_type=mysql_query($sql_type, $connection); $row_type=mysql_fetch_array($result_type); $sql_mfter="SELECT naam FROM mfter WHERE mfter_id=\"".$s_brand."\""; $result_mfter=mysql_query($sql_mfter); $row_mfter=mysql_fetch_array($result_mfter); $displ_query="

".$row_mfter['naam']." ".$row_type['type']." cranes

"; $searchstring=$row_mfter['naam']." ".$row_type['type']." cranes"; $ttl_type=$row_type['type']." "; $ttl_brand=$row_mfter['naam']." "; unset($mfter_link); } if ($search==6) { // BRAND + CAPACITY if (!isset($order)) { $order=" tonnage ASC"; } $sql.="AND manufacturer=\"".$s_brand."\" AND tonnage>=\"$query_tons_min\" AND tonnage<=\"$query_tons_max\" ORDER BY ".$order.""; $sql_mfter="SELECT naam FROM mfter WHERE mfter_id=\"".$s_brand."\""; $result_mfter=mysql_query($sql_mfter, $connection); $row_mfter=mysql_fetch_array($result_mfter); $plus=$s_capacity+50; $displ_capacity="".$s_capacity." - ".$plus; if ($capacity==800) { $displ_capacity="over 800"; } $displ_query="

".$displ_capacity." ton ".$row_mfter['naam']." cranes

"; $searchstring=$displ_capacity." ton ".$row_mfter['naam']." cranes"; $ttl_brand=$row_mfter['naam']." "; $ttl_capacity=$displ_capacity." ton "; } if ($search==7) { // TYPE + BRAND + CAPACITY if (!isset($order)) { $order=" manufacturer_name ASC"; } $sql.="AND type=\"".$s_type."\" AND manufacturer=\"".$s_brand."\" AND tonnage>=\"$query_tons_min\" AND tonnage<=\"$query_tons_max\" ORDER BY ".$order.""; $sql_type="SELECT type FROM types WHERE type_id=\"".$s_type."\""; $result_type=mysql_query($sql_type, $connection); $row_type=mysql_fetch_array($result_type); $sql_mfter="SELECT naam FROM mfter WHERE mfter_id=\"".$s_brand."\""; $result_mfter=mysql_query($sql_mfter, $connection); $row_mfter=mysql_fetch_array($result_mfter); $plus=$s_capacity+50; $displ_capacity="".$s_capacity." - ".$plus; if ($capacity==800) { $displ_capacity="over 800"; } $displ_query= "

".$displ_capacity." ton ".$row_mfter['naam']." ".$row_type['type']." cranes

"; $searchstring=$displ_capacity." ton ".$row_mfter['naam']." ".$row_type['type']." cranes"; $ttl_capacity=$displ_capacity." ton "; $ttl_brand=$row_mfter['naam']." "; $ttl_type=$row_type['type']." "; } // echo $sql."
search= ".$search; exit; $result=mysql_query($sql, $connection); $n=mysql_num_rows($result); $displ_n_query="$n results:

"; if ($n==1) { $displ_n_query="$n result:

"; } if ($n==0) { $displ_n_query="$n results

"; } $displ_query=$displ_query."".$displ_n_query.""; $x=0; if ($n>0) { $display_search="

Search results

" .$displ_query."New search    ".$sortspecials."
"; while(($row_search=mysql_fetch_array($result)) && ($n!=0)) { $sql_mfter="SELECT naam FROM mfter WHERE mfter_id=\"".$row_search['manufacturer']."\""; $result_mfter=mysql_query($sql_mfter, $connection); $row_mfter=mysql_fetch_array($result_mfter); $sql_model="SELECT model FROM models WHERE model_id=\"".$row_search['model']."\""; $result_model=mysql_query($sql_model, $connection); $row_model=mysql_fetch_array($result_model); $sql_type="SELECT type FROM types WHERE type_id=\"".$row_search['type']."\""; $result_type=mysql_query($sql_type, $connection); $row_type=mysql_fetch_array($result_type); $d_spec=" "; if ($row_search['special']>0) { $spec=" class=\"s_result_spec\""; $d_spec="special!"; } if ($row_search['no_price']==1) { $price="on demand"; } if ($row_search['no_price']==0) { $price=$row_search['unit_currency']." ".number_format($row_search['price'], 0, '', '.'); } $display_search.=" "; $x++; $n--; unset($row_mfter, $row_model, $row_type, $result_mfter, $result_model, $result_type, $spec, $d_spec); } $display_search.="
".$mfter_link.$model_link." ".$type_link." ".$cap_link." ".$yom_link." ".$price_link."
".$row_mfter['naam']." ".$row_model['model']." $d_spec ".$row_type['type']." ".$row_search['tonnage']." ".$row_search['unit_weights']." ".$row_search['yom']." ".$price."


"; $_SESSION['search_capacity']=$s_capacity; $_SESSION['search_type']=$s_type; $_SESSION['search_brand']=$s_brand; unset($posted); } else { $display_search="

Search results

New search   
".$displ_query."
No matches found!
Search the web with Google:
\"Google\"

Sponsored links:


"; unset($_SESSION['search_capacity'], $_SESSION['search_type'], $_SESSION['search_brand'], $search_session); } $s_results=1; $content=$display_search; $head_ttle=$ttl_brand.$ttl_capacity.$ttl_type." cranes for sale or for rent at Online Cranes"; $head_descr=""; ?> <? echo $head_ttle; ?>
".$content."
"; if (($_GET['sect']!="ua") && ($_GET['sect']!="pp") && ($_GET['sect']!="search") && ($_GET['sect']!="links") && (!isset($_GET['show'])) && ($s_results!=1) && ($_GET['sect']!="parts") && ($_GET['sect']!="repair") && ($_GET['sect']!="finance")) { $brand_list=" Brand: "; $type_list="Type: "; $capacity_list="Capacity: "; //include ("create_list.inc.php"); include ("create_partners_table.inc.php"); //

Show all cranes for sale or for rent >>

echo "
Register:
In order to list your cranes for sale, rent and/or to receive our newsletter you need to REGISTER at OnlineCranes. Registering is free. If you've already registered at OnlineCranes, please LOGIN to manage your online cranes!

Search Cranes for sale and for rent at OnlineCranes:

".$type_list." ".$brand_list." ".$capacity_list."
".$partners_table."
Brands: Types:
".$display_brandlist." ".$display_typelist."

"; } ?> nothing
 OnlineCranes