steve55

Thanks, tried though and am now looking at a blank white page....

Thanks, but that is basically the same code as I have pasted above that isn't working...

Hi Still stuck on this...If anyone can help that would be ideal... Many thanks

Thanks - How do I add the form field to my code though (sorry) I'm trying this, but it isn't working : <form name=persons method=post action=process.php > <select name="Persons"> <?php while($rows=mysql_fetch_array($result)){ ?> <option value="<?php echo $rows['id']; ?>"> <?php echo $rows['FirstName']; ?></option> <?php } ?> </select> </form>

I'm using some code to create a select menu of a fieldname of data I have in a mysql database : <?php mysql_connect('localhost' , 'dbname', 'password'); mysql_select_db('dbname'); $result=mysql_query("SELECT * FROM Persons"); if(mysql_num_rows($result)>0) { ?> <select name="Persons"> <?php while($rows=mysql_fetch_array($result)){ ?> <option value="<?php echo $rows['id']; ?>"> <?php echo $rows['FirstName']; ?></option> <?php } ?> </select> What I would like to do is to elevate this into a jump menu form so that if the user selects an item from my form they are taken to a results page showing the full row of data from the database. Basically a search form containing items from the database they can choose to see more details on. eg. In my example you select a persons name and then you are taken to a results page which displays the details of that person from the database. Problem is I don't know how to do this and have been trawling around for a couple of days to find a solution (sorry I'm new to php). I would appreciate some help or a working example would be great of : 1/ A working dynamic jump menu 2/ The page that would process the form 3/ The results page displaying the data I have selected. Thank you for your time...

Hi I have just redesigned my website and was wondering if you could spare some time to give me some feedback and thoughts please. I'm particularly interested on thoughts re the look & feel, is it engaging, can you find what you want, can you contact me...etc. Thank you! www.stevesims.com