html select, and inserting to var. ?!

[Richi]

Hi all again !

now i just wanna know this, i have html select which will sort the sub_cat, sub_cat_id, and catagory :

$sql_cat="select * from subcat";
$result_cat=@mysql_query($sql_cat,$db);

echo "<select name=\"newsub_cat\">";

          while($mycat=@mysql_fetch_array($result_cat))
    {

$sub_cat=$mycat["sub_cat"];
$sub_cat_id=$mycat["sub_cat_id"];
$catagory=$mycat["catagory"];

  echo"<option value=\"$sub_cat\">:: $catagory  :::  $sub_cat :::  $sub_cat_id ::</option>";

}


echo"</select>";
?> 

with this way i can insert just the sub_cat, i need to insert the catagory also into another table which include catagory and sub_cat field ?

i was trying with this :

$query = mysql_query("Select catagory from subcat where newsub_cat='$sub_cat'",$db);
list($sub_cat_id, $sub_cat, $catagory) = mysql_fetch_row($query);

echo "[$catagory] $newsub_cat";
$newcat=$catagory; 

but didn`t work !

[lynlimz]

use UPDATE...

From the mySQL Documentation

http://www.mysql.com/doc/U/P/UPDATE.html

[Richi]

ok, i know that, but here i have var.,from this var. i need to update or to insert to db. 2 var. !

when i select from the html select, ill choose the sub_cat, which i can insterted to the db. but how can i insert also this sub_cat main catagory also into the db. ?

Field Type Attributes Null Default Extra Action 
sub_cat_id  int(7)    No    auto_increment  Change Drop Primary Index Unique 
sub_cat  varchar(30)    Yes      Change Drop Primary Index Unique 
catagory  varchar(30)    No

see, when i select the sub_cat also there are catagory !

[Richi]

done with this code :

$query = mysql_query("Select * from subcat where sub_cat='$newsub_cat'");
    $count = mysql_num_rows($query);

    $h = mysql_fetch_array($query);
echo "[".$h[catagory]."]";
$catagory1= $h[catagory];