if the problem is only the assigning it's an example:
in mysql you can have this one:
create table store_list(id_markets int auto_increment,store_type int,primary

and for page this one:


<form method="post">
if(isset($_POST['store_type']) )
$Type =$_POST['store_type'];
  $sql ="update store_list set store_type=$Type where id_markets=$ID";
$res = mysql_query($sql,$connection);
<select name='store_type'>
<option value=0>store type<option>
<option value=1>corporate<option>
<option value=2>standard<option>
ID:<input type='text' name='id'>
<input type='submit' name='sub' value='update the type'>

also I didn't understand your code that you have 'id_store' and 'id_markets'
it's confusing for me

if it wasn't your problem please clarify your question maybe I can help.

Reply via email to