update problem

[zuzupus]

hi,
i created 3 fields

<form action="dirmodify.php" method="post">

<tr>
<td> <input type="radio" name="ddir" value="<?=$r->sys_pk ?>" id="dir<?=$r->sys_pk ?>" /></td>
<td>Directory:&nbsp;</td>
<td><input type="text" name="name" size="20" /></td>
<td><input type="submit" name="modify" value="Modify"</td>
</tr>
</form>
this radio display some files from database when i select some file let say FORUM it display in text field and when i chnage the name to FORUM1 and submit the form its not at all updating name i dont no why

and in dirmodify.php

<? $dir = './'; require($dir.'lib.php'); get_session(); ?>
<?
expire_header();
$ddir = $HTTP_POST_VARS['ddir']+0;
// modifying directories
         if ($modify && $ddir) {
   query_db_trad("UPDATE t_directories SET name = $name WHERE sys_pk = $ddir");//whats wrong in this query
           }

?>

thanks in advance

[eoghain]

<? $dir = './'; require($dir.'lib.php'); get_session(); ?> 
<? 
expire_header(); 
$ddir = $HTTP_POST_VARS['ddir']+0; 
// modifying directories 
         if ($modify && $ddir) { 
   query_db_trad("UPDATE t_directories SET name = '$name' WHERE sys_pk = $ddir");//whats wrong in this query 
           } 

?> 

Try that. Most databases need you to tell them that you are trying to set a string value, so you need to surround your strings with quotes.

[zuzupus]

thanks alot now it working fine sorry for ur inconvenience.