Update to MySQL
<p>I`m stuck again with this script, i am now trying to update an existing client in table "wdclient" but no update goes though to the database.</p>

<p>Trying to insert "products" and "description".</p>

<p>Here is my code:</p>

<pre><code>$id=$_GET['id'];
$clientId=$_GET['clientId'];
include ('msql_connect.php');
include ('msql_open.php');
include ('header.php'); 

    $base1 = '&lt;option value="';
    $base2 = '"&gt;';
    $base3 = '&lt;/option&gt;';

     if(isset($_POST['submit'])) {

mysql_query("UPDATE wdclient (cdetail, cproducts) WHERE clid = '$clientId'
VALUES ('$_POST[detail]', '$_POST[products]')");

mysql_query("INSERT INTO wdccat (caid, clid) VALUES ('$_POST[category1]','$_POST[clid]')");

mysql_query("INSERT INTO wdccat (caid, clid) VALUES ('$_POST[category2]','$_POST[clid]')");

mysql_query("INSERT INTO wdccat (caid, clid) VALUES ('$_POST[category3]','$_POST[clid]')");

mysql_query("INSERT INTO wdccat (caid, clid) VALUES ('$_POST[category4]','$_POST[clid]')");
     }

?&gt;
    &lt;div class="tagline"&gt; 
        &lt;h1&gt;Finish your Registration!&lt;/h1&gt; 
        &lt;span&gt;&lt;em&gt;Complete your Registration!&lt;/em&gt;&lt;/span&gt;
      &lt;div class="clear"&gt;&lt;/div&gt;
    &lt;/div&gt; 
    &lt;div class="wrapper"&gt;                       
                    &lt;form method="post" action="&lt;?php echo $_SERVER['PHP_SELF']; ?&gt;" id="contactform" class="big_form" &gt;    
    &lt;div id="section1"&gt; 
    &lt;?php 
    $SQL = "SELECT * FROM wdcat ORDER BY `ccname` ASC";
    $result = mysql_query($SQL);

    while ($db_field = mysql_fetch_assoc($result)) {

    }
    ?&gt; 
&lt;table width="1000" border="0"&gt;
  &lt;tr&gt;
    &lt;th width="185" scope="col"&gt;&amp;nbsp;&lt;/th&gt;
    &lt;th colspan="2" scope="col"&gt;&lt;h2 &gt;Choose up to 4 Categories:&lt;/h2&gt;&lt;/th&gt;
    &lt;th width="30" scope="col"&gt;&amp;nbsp;&lt;/th&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td width="308"&gt;&lt;label for="text"&gt;&lt;b style="color:#C00"&gt;*&lt;/b&gt; Select Category:&lt;/label&gt;&lt;select name="category1" id="category1" value="" class="required"&gt;&lt;?php $SQL = "SELECT * FROM wdcat ORDER BY `ccname` ASC";
    $result = mysql_query($SQL);

    while ($db_field = mysql_fetch_assoc($result)) {

    echo $base1;
    print $db_field['ccid'];
    echo $base2;
    print $db_field['ccname'];
    echo $base3;

    };?&gt;&lt;/select&gt;&lt;/td&gt;
    &lt;td width="459"&gt;&lt;label for="text"&gt;&lt;b style="color:#C00"&gt;*&lt;/b&gt; Select Category:&lt;/label&gt;&lt;select name="category2" id="category2" value="" class="required"&gt;&lt;?php $SQL = "SELECT * FROM wdcat ORDER BY `ccname` ASC";
    $result = mysql_query($SQL);

    while ($db_field = mysql_fetch_assoc($result)) {

    echo $base1;
    print $db_field['ccid'];
    echo $base2;
    print $db_field['ccname'];
    echo $base3;

    };?&gt;&lt;/select&gt;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td&gt;&lt;label for="text"&gt;&lt;b style="color:#C00"&gt;*&lt;/b&gt; Select Category:&lt;/label&gt;&lt;select name="category3" id="category3" value="" class="required"&gt;&lt;?php $SQL = "SELECT * FROM wdcat ORDER BY `ccname` ASC";
    $result = mysql_query($SQL);

    while ($db_field = mysql_fetch_assoc($result)) {

    echo $base1;
    print $db_field['ccid'];
    echo $base2;
    print $db_field['ccname'];
    echo $base3;

    };?&gt;&lt;/select&gt;&lt;/td&gt;
    &lt;td&gt;&lt;label for="text"&gt;&lt;b style="color:#C00"&gt;*&lt;/b&gt; Select Category:&lt;/label&gt;&lt;select name="category4" id="category4" value="" class="required"&gt;&lt;?php $SQL = "SELECT * FROM wdcat ORDER BY `ccname` ASC";
    $result = mysql_query($SQL);

    while ($db_field = mysql_fetch_assoc($result)) {

    echo $base1;
    print $db_field['ccid'];
    echo $base2;
    print $db_field['ccname'];
    echo $base3;

    };?&gt;&lt;/select&gt;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td colspan="2"&gt;&lt;br/&gt;
    &lt;h2&gt;Company Information:&lt;/h2&gt;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td&gt;&lt;label for="description"&gt;&lt;b style="color:#C00"&gt;* &lt;/b&gt;Company Description:&lt;/label&gt;
    &lt;textarea name="detail" id="detail" cols="40" rows="8"&gt;&lt;/textarea&gt;&lt;/td&gt;
    &lt;td&gt;&lt;label for="description"&gt;&lt;b style="color:#C00"&gt;* &lt;/b&gt;Products: (eg, shoes, bedding, tableware)&lt;/label&gt;
    &lt;textarea name="products" id="products" cols="40" rows="8"&gt;&lt;/textarea&gt;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td colspan="2"&gt;&lt;br/&gt;
    &lt;h2&gt;Upload Images:&lt;/h2&gt;&lt;br/&gt;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td&gt;&lt;input type="hidden" name="clid" id="clid" value="&lt;?php echo $clientId ;?&gt;"&gt;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td&gt;&lt;input type="submit" value="Complete Registration" name="submit" class="button form" /&gt;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
  &lt;/tr&gt;
&lt;/table&gt;
&lt;/div&gt;
&lt;/form&gt;

            &lt;div class="clear"&gt;&lt;/div&gt;                   
&lt;/div&gt;
&lt;/div&gt;
&lt;?php include ('msql_close.php'); ?&gt;
&lt;?php include('footer.php'); ?&gt;
</code></pre>

<p>Any assistance will be appreciated.
Thanks</p>
