Thanks for your reply Ray. I have had another go with your input but still can't get it to work.
Firstly I am attempting this with the search and results on the same page. Assuming the is possible
Here's my record set..
<?php
mysql_select_db($database_LA, $LA);
$query_rsMembersList = "SELECT members.members_id, members.app_date, members.first_name, members.surname, members.property_id, properties.property_id, properties.estate_name, properties.street_address FROM members, properties WHERE members.property_id = properties.property_id";
setQueryBuilderSource($query_rsMembersList,$WADbSearch1,false);
setQueryBuilderSource($query_rsMembersList,$WADA_Sort_1,false);
$rsMembersList = mysql_query($query_rsMembersList, $LA) or die(mysql_error());
$row_rsMembersList = mysql_fetch_assoc($rsMembersList);
$totalRows_rsMembersList = mysql_num_rows($rsMembersList);
I want to search the following ways:
- By first letter of 'first_name'
- By first letter of 'surname'
- By 'estate_name'
- By 'street_address'
Before I was using url with parameters to hold the values for 'first letter of first_name and surname' such as:
<a class="btn btn-default" role="button" href="members-list-t.php?first_name=A">A</a>
<a class="btn btn-default" role="button" href="members-list-t.php?surname=A">A</a>
I would use one of these for every letter of the alphabet.
For the searches by 'estate_name and street_address' I was using forms with a select list such as:
<form method="post" name="select-member-by-estate" id="select-member-by-estate" action="">
<div class="form-group">
<select class="form-control" id="estate_name" name="estate_name">
// repeat region
<option value="<?php echo $row_rsProperty['estate_name']; ?>"><?php echo $row_rsProperty['estate_name']; ?></option>
// end repeat region
</select>
<input name="submit-member-choice-a" class="btn btn-default" type="submit" value="Select">
</form>
So far I've tried to use the forms with the data search behaviour but without success. Ive attached some screen shots of the Data Search settings and the page. Can you see where I am going wrong?
Thanks in advance.