Thanks Metho - I'll probably move this posting later Twitch , I'm just not sure if my problem is MySQL / PHP related or just something to do with HTML...
The code for the Form submit page is simply:
<form action="Lisa1.php"rightFrame" " method="get" name="form1">
<p>
<select name="language" id="language">
<option value="English">English</option>
<option value="French">French</option>
<option value="Spanish">Spanish</option>
<option value="Chinese">Chinese</option>
<option value="German">German</option>
</select>
...
(And also the same for prefectures in Japan)
The page it submits the seacrh results to (Lisa1.php - The Master / Details page) is
<?php require_once('Connections/connectiona.php'); ?>
<?php
$colname_b = "1";
if (isset($_GET['recordID'])) {
$colname_b = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_connectiona, $connectiona);
$query_b = sprintf("SELECT autonumber, sex, firstname, fullname, age, nationality, `language`, OthLanguage, teachingexperience, LangSchls, LangQual, qualifications, otherexper, TMethd, jap_ability, likes, dislikes, fav_movie, areas, prefecture, mm, ma, me, tm, ta, te, wm, wa, we, thm, tha, the, fm, fa, fe, sm, sa, se, `sum`, sua, sue, private_price, group_price, message, contactmail, contactnum FROM TestTable WHERE autonumber = %s", $colname_b);
$b = mysql_query($query_b, $connectiona) or die(mysql_error());
$row_b = mysql_fetch_assoc($b);
$totalRows_b = mysql_num_rows($b);
$maxRows_s = 30;
$pageNum_s = 0;
if (isset($_GET['pageNum_s'])) {
$pageNum_s = $_GET['pageNum_s'];
}
$startRow_s = $pageNum_s * $maxRows_s;
$varlanguage_s = "English";
if (isset($language)) {
$varlanguage_s = (get_magic_quotes_gpc()) ? $language : addslashes($language);
}
$varprefecture_s = "Tokyo";
if (isset($prefecture)) {
$varprefecture_s = (get_magic_quotes_gpc()) ? $prefecture : addslashes($prefecture);
}
mysql_select_db($database_connectiona, $connectiona);
$query_s = sprintf("SELECT TestTable.autonumber, TestTable.firstname, TestTable.nationality, TestTable.private_price, TestTable.sex FROM TestTable WHERE TestTable.`language`= '%s' AND TestTable.prefecture = '%s' ", $varlanguage_s,$varprefecture_s);
$query_limit_s = sprintf("%s LIMIT %d, %d", $query_s, $startRow_s, $maxRows_s);
$s = mysql_query($query_limit_s, $connectiona) or die(mysql_error());
$row_s = mysql_fetch_assoc($s);
if (isset($_GET['totalRows_s'])) {
$totalRows_s = $_GET['totalRows_s'];
} else {
$all_s = mysql_query($query_s);
$totalRows_s = mysql_num_rows($all_s);
}
$totalPages_s = ceil($totalRows_s/$maxRows_s)-1;
?>
<html>
.....
'Tokyo' and 'English' are the default values I specified (if no values are entered in the search box), and the problem is that after I click on a record brought up by the search parameters, the list then displays those Tokyo and English default values - and no longer the list created due to the search.
Thanks again, and I'll let you all know if I make any progress...
