Dropdown menus to select clients

jsims

Hi;

I first want to thank everyone for all they help you have provided.

OK I have several tables where I want to enter data on a specific student. The students name is in my cleints table, as is a automatically generated ID.

Eventrually want to build a generic page that will provide me with a dropdown or the clients or the organization or the casemanager so they can select specific information.

I will settle for some ideas on just generating the first part which I think is the drop down menu.

Thanks

acrabadabra

What exactly do you want to do with the dropdowns? You want to generate them? Or is your question about linking the dropdowns to your client?

jsims

Welll actually I want to do both. but since I will have several scripts that will require I thought the best thing to do was first develop the drop down and then start working on generating the script that would do the remainder of the job.

As I have said in the past, I am new to php, but I have ordered a couple of books that have been recommended and I am attempting to learn as much as I can on my own. Honest I am trying.

Hope this answers your question.

Thanks

John

acrabadabra

Just grabbed some examples from the net, since there are plenty to be found.

Inserting values into your table:

// Insert a row of information into the table "example"
mysql_query(
"INSERT INTO example 
(name, age) VALUES('Timmy Mellowman', '23' ) ") 
or die(mysql_error());

Retrieve all the data from the "example" table

$result = mysql_query("SELECT * FROM example") 
or die(mysql_error());

store the record of the "example" table into $row ($row becomes an array with all data selected)

$row = mysql_fetch_array( $result );

// Print out the contents of the 1st row 
echo "Name: ".$row['name'];
echo " Age: ".$row['age'];

But you want to create a pulldown with the results.. so you want to make a loop and so create your pulldown.

$selectAry = '';
while($row = mysql_fetch_array( $result )) 
{
	$selectAry .= '<OPTION VALUE="' . $row['age'] . '">'. $row['name'] .'</OPTION>';
}

echo '<SELECT NAME="">'. $selectAry .'</SELECT>';

Hope this will get you on your way to become an expert ;-)

PS. Don't forget to close the thread when your answer has been answered.