Hi all. I have a table called students. In it two columns are Firstname and Surname.
I have a dropdown selection which I want to pull from both those columns and then when the form is submitted they get written to another table also with Firstname and Surname. I have managed the first part but am stuck on the second part when the separate colums get posted back to the database.
[php]
<?php $options = ''; $filter=mysql_query("select * from students"); while($row = mysql_fetch_array($filter)) { $options .="" . $row['firstname'] . " " .$row['surname'] . ""; } $menu="As I say the first part when it pulls the firstname and surname works but the second part is a little beyond me at this point.
Thanks all for looking at this.
Paul