update
Hi Jason
think I've got it;-)
the code I created is here and I've attatched the original and modified file.
The idea is that the selected price is returned itif it is within 5000 of the typed in figure.
can you take a look and tell me if I've suceeded as (to no surprise) it does not work for me.
thanks
Ian
<?php
$maxRows_WADAboats = 3;
$pageNum_WADAboats = 0;
if (isset($_GET['pageNum_WADAboats'])) {
$pageNum_WADAboats = $_GET['pageNum_WADAboats'];
}
$startRow_WADAboats = $pageNum_WADAboats * $maxRows_WADAboats;
mysql_select_db($database_conn_localhost, $conn_localhost);
$query_WADAboats = "SELECT id, dt_name, dt_type, dt_Price, dt_loa, dt_berths, dt_short_desc, dt_catch_phrase, dt_yearBuilt, dt_construction, dt_designer, dt_builder, dt_underwaterProfile, dt_engine, dt_lying, dt_boatImageThumbnail, dt_thumbnail_alt, dt_boatImage1, dt_image1_alt, dt_boatImage2, dt_image2_alt, dt_boatIimage3, dt_image3_alt, dt_boatImage4, dt_image4_alt, dt_boatImage5, dt_image5_alt, dt_long_desc, es_electricsDetails, ct_constructionDetails, wt_waterDetails, acc_cooker, acc_icebox, acc_curtains, acc_pws, acc_fws, acc_nonsmoke, acc_handbasin, acc_shower, acc_heads, acc_sink, acc_fridge, acc_hws, acc_cockpitShower, acc_microwave, acc_cabinHeating, accd_details, nav_compass, nav_log, nav_gps, nav_autopilot, nav_navlights, nav_wind, nav_echosounder, nav_vhfRadio, nav_chartPlotter, nav_stereo, nav_details, ed_fuelCapacity, ed_holdingTank, ed_waterCapacity, ed_LastSurvey, mech_engine, mech_engineHours, mech_waterCooled, mech_steering, mech_fuelComsumption, mech_cruisingSpeed, mech_maxSpeed, mech_details, dim_loa, dim_lwl, dim_beam, dim_draftMmin, dim_draftMax, dim_displacement, dim_headroom, dim_storage, rig_rig, dg_sailCover, dg_warps, dg_boathook, dg_swimLadder, dg_bimini, dg_sprayhood, dg_fenders, dg_swimPlatform, dg_instrumentCovers, dg_details, sft_gasDetector, sft_lifeBuoys, stf_emergencySteering, sft_saftHarness, stf_details, sails_reefMainsail, sails_headsail, sails_halyardWinches, sails_sheetWinches, sails_otherSails, sails_spinakerGear, sails_desc, brokerFirstName, brokerLastName, brokerCity, brokerZip, brokerRegistrationDate, brokerPhone, brokerMobile, brokerAddress, brokerAddress2, brokerState, brokerCountry FROM boats ORDER BY dt_Price ASC";
setQueryBuilderSource($query_WADAboats,$WADbSearch1,false);
$query_limit_WADAboats = sprintf("%s LIMIT %d, %d", $query_WADAboats, $startRow_WADAboats, $maxRows_WADAboats);
$WADAboats = mysql_query($query_limit_WADAboats, $conn_localhost) or die(mysql_error());
$row_WADAboats = mysql_fetch_assoc($WADAboats);
if (isset($_GET['totalRows_WADAboats'])) {
$totalRows_WADAboats = $_GET['totalRows_WADAboats'];
} else {
$all_WADAboats = mysql_query($query_WADAboats);
$totalRows_WADAboats = mysql_num_rows($all_WADAboats);
}
$totalPages_WADAboats = ceil($totalRows_WADAboats/$maxRows_WADAboats)-1;
?>