Ok Russell,
Still not sure how much PHP/MySQL you know so let's deal with that first. Do you understand what's going below ...
<?php
// Put your host/user/password details in the next line ...
mysql_connect("localhost", "root", "password");
$result = mysql_query("SELECT * FROM table1 ORDER BY destination");
// Build the list of options to be used in BOTH selects
$options = array();
while ($row = mysql_fetch_array($result)){
$options[] = '<option value="'.$row['rate'].'">'.$row['destination'].'</option>';
}
?>
<html>
<head>
<title>Test</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="">
<table width="200" border="0">
<tr><td>calling from ></td></tr>
<tr><td><select name="select_from"><?php echo join('', $options); ?></select></td></tr>
<tr><td>calling to ></td></tr>
<tr><td><select name="select_to"><?php echo join('', $options); ?></select></td>
<tr><td><input type="submit" name="Submit" value="Go"></td></tr>
</table>
</form>
</body>
</html>
But the issues after this are going to be ...
1) What does this 'rate' in the DB refer to? Is it the rate calling from the UK, say?
2) Are these ALL the fields in table1, and if not, is there a PRIMARY KEY field?
Paul 🙂
