Thank you so much for a reply, herewith the entire select box code:
The select name here corresponds to the "training" variable used on the mail.php script, and it does work, it's just that it only takes the first word of the training course name not the entire "sentence", but it does show all the choices that are made,
this is the select code, see comments in bold within the code almost last line:
<SELECT name="training[]" size="5" multiple="multiple" id="training">
<?
include("courses/admin_courses/cal_db_conn.php");
$sho = $_GET['sho']; // display method
$link = mysql_connect($db_host, $db_login, $db_pass) or die ("Error: Unable to connect to the database.");
$db = mysql_select_db($db_name) or die ("Error: Unable to open the database.");
// Get all records
$sql = "SELECT FROM tablename ORDER BY NAME";
$sql_result = mysql_query($sql,$link);
$query=("select * from tablename ORDER BY NAME");
$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() );
while($myrow=mysql_fetch_array($result)){
echo "<OPTION VALUE="['name']">".$myrow['name']."</OPTION>";
In the above line of code the first 'name' was originally the 'id', but I changed this as it showed the id value - and I wanted it to show the Name of the course.
}
?>
</SELECT>
Your assistance is most appreciated, I've searched google (and still haven't found an answer -) although I think it's something to do with the spaces in the stored value.
