Thanks, sorry for not responding before but I've been away for a few days.
I looked at the recordset that DA created and it shows the variable WADAlocation which I assume is the URL parameter that you refer to?
The code for the recordset is:
<?php
$maxRows_WADApracticelist = 10;
$pageNum_WADApracticelist = 0;
if (isset($_GET['pageNum_WADApracticelist'])) {
$pageNum_WADApracticelist = $_GET['pageNum_WADApracticelist'];
}
$startRow_WADApracticelist = $pageNum_WADApracticelist * $maxRows_WADApracticelist;
$WADAlocation_WADApracticelist = "-1";
if (isset($_POST['location'])) {
$WADAlocation_WADApracticelist = (get_magic_quotes_gpc()) ? $_POST['location'] : addslashes($_POST['location']);
}
mysql_select_db($database_connGVG, $connGVG);
$query_WADApracticelist = "SELECT practice_id, practicename, address1, address2, address3, address4, postcode, location, practicewebsite, practicetype, starrating FROM practicelist ORDER BY practicename ASC";
setQueryBuilderSource($query_WADApracticelist,$WADbSearch1,false);
$query_limit_WADApracticelist = sprintf("%s LIMIT %d, %d", $query_WADApracticelist, $startRow_WADApracticelist, $maxRows_WADApracticelist);
$WADApracticelist = mysql_query($query_limit_WADApracticelist, $connGVG) or die(mysql_error());
$row_WADApracticelist = mysql_fetch_assoc($WADApracticelist);
if (isset($_GET['totalRows_WADApracticelist'])) {
$totalRows_WADApracticelist = $_GET['totalRows_WADApracticelist'];
} else {
$all_WADApracticelist = mysql_query($query_WADApracticelist);
$totalRows_WADApracticelist = mysql_num_rows($all_WADApracticelist);
}
$totalPages_WADApracticelist = ceil($totalRows_WADApracticelist/$maxRows_WADApracticelist)-1;
?>
I also have a related issue which I'm not clear about resolving:
I want to have a second form which is essentially an upload form which will allow people to post reviews for the different Practices to the Reviews table, but I want to have the list of practices as a drop-down list/menu at the top of the form so that the review is then associated with the correct practice.
Is this as simple as creating a recordset from the practice table at the top of the form then creating the rest of the form to upload to the reviews table, or is it more complicated than that? As always, your help is much appreciated.
