[SOLVED] insert from an drop-down list

[ionnnnutz]

i have a table in wich i've inserted city's name.then i have an registration form in wich  i want to display an dropdown list with the cities from the table, and if one city is selected to be automaticly added in the second table. how can i do that? thanks

[MadTechie]

using insert...

 

what code do you have ?

[ionnnnutz]

<form id="form1" name="form1" method="get" action="<? echo $PHP_SELF; ?> ">
			<select name="select">
				<?php


				$list=mysql_query("select * from domenii_comp");


				while($row_list=mysql_fetch_assoc($list)){
				?>
				<option value="<? echo $row_list['id']; ?>" 
							   <? if($row_list['comp_domeniu']==$select){ echo "selected"; } ?>>
							   <? echo $row_list['domeniu']; ?></option>
				<?php

				}
				?>
			</select>
               <input type="submit" name="Submit" value="adauga!" class="sbtn"/>
		</form>

[MadTechie]

you need to use something like

<?php
mysql_query("INSERT INTO secondtable ($_GET['select']) VALUES ('field')");
?>

[ionnnnutz]

thanks  that worked!

 

[MadTechie]

Cool

 

Oh Please Click Solved

[soycharliente]

It's at the very bottom of the thread on the left.