[zenix]

Hello, I have been learning php/mysql for about a year now and have made some pretty decent progress. I've made a database for a fake company in order to practice what I have learned. Well, I came up with an idea I thought would be kind of neat. I have my database working well. I thought it'd be convenient if there was a way for me to have a text box at the top of the form containing first name, last name and phone numbers for each entry in the database, so I can scroll through, find the one I want and then click it to have all the info displayed in the form.

I have first and last names, address 1 and 2, city, state, zip, phone and email. Has anyone got any idea how I might achieve this? I've been studying AJAX for all of about a month now...it seems as though this would make sense. Am I at least warm?

Thank you very much for your time!

[ruteckycs]

Use drop downs instead of a textbox

[zenix]

Thank you, my hang up is I haven't got a clue as to how to even start populating any sort of box with the data. Any guidance would be SO appreciated.

[ruteckycs]

PHP Code:

<?php

include("connect.php");

$result = mysql_query("SELECT * FROM Catagory ORDER BY Catagory ASC"); 

echo "<select name=\"MyDropDown\">";
while($row = mysql_fetch_array( $result )) {
    $MYData=$row['MyROW'];
        echo "<option>$MYData</option>";
}
echo "</select>";
?>

Not tested but should be fine. Connect.php is your include to connect and select database, replace MyROW with your field name.

[zenix]

Thank you for your advice, I really appreciate you having taken your time to assist me. I will learn a lot from this!