simple dropdown

[rasmas]

Hi All

I have 2 tables in a mysql database
Customer_list
- cus_id
- Customer name[/code]
Machine_list
- cus_id
- machine_id
- machine_name

I want a dropdown list listing the Customer names, once a name has been select the machine id and name must be displayed

I have the following code

$form_mach_edit ="<form name = \"customer\" action=\"$self\" method=\"post\">";
      $form_mach_edit .="<select name='Cus_ID'>";
								while ($row_cus = mysql_fetch_array($rs_cus))
										{
		  								#$Cus_ID =$row_cus['Cus_ID'];
      								$Customer_Name =$row_cus['Customer_Name'];
      $form_mach_edit .="<option value ='$Cus_ID'>$Customer_Name </option>";
    								}
	  	$form_mach_edit .="</select>";
			$form_mach_edit .="<input type=\"submit\" value=\"Update\">";
			$form_mach_edit .="</form>";
			$form_mach_edit .="<BR>";

I then search the data base using the cus_id to then dislpay the details.

I am having trouble with the code above as I dont get a cus_id to use in my search

Thanks for the help

Martin

[bastien]

Debug it then:

1. view the source of the page and see if the forms action is pointing back to where it needs to go on the server
2. add echo statements to check that you are getting the correct values passed back

[rasmas]

I have been trying to debug it

the list is populated but when I echo the $Cus_id it is blank.
The form submits to the same file as the rest of my code is in the same file. If I put the $Cus_id in manualy the rest of my code works.

Thanks
Martin

[bastien]

Dunno if its a typo, but $Cus_id is not the same as $Cus_ID . Make sure the case is the same on the vairables