show all rows from database table as default
I have the following record set which I'm using to view data from a database table with url variables and form variables.
$beginsB_rsMembersList = "-1";
if (isset($_GET['surname'])) {
$beginsB_rsMembersList = $_GET['surname'];
}
$estateName_rsMembersList = "-1";
if (isset($_POST['estate_name'])) {
$estateName_rsMembersList = $_POST['estate_name'];
}
$streetName_rsMembersList = "-1";
if (isset($_POST['street_address'])) {
$streetName_rsMembersList = $_POST['street_address'];
}
$FirstNameBegins_rsMembersList = "-1";
if (isset($_GET['first_name'])) {
$FirstNameBegins_rsMembersList = $_GET['first_name'];
}
mysql_select_db($database_LA, $LA);
$query_rsMembersList = sprintf("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) AND (members.surname LIKE %s OR members.first_name LIKE %s OR properties.estate_name = %s OR properties.street_address = %s)", GetSQLValueString($beginsB_rsMembersList . "%", "text"),GetSQLValueString($FirstNameBegins_rsMembersList . "%", "text"),GetSQLValueString($estateName_rsMembersList, "text"),GetSQLValueString($streetName_rsMembersList, "text"));
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);
The problem Ive got is I want all results from table to show as default when a user first enters the web page.
Help Please.
Ive attached the full page.
Thanks in advance