update problem

zuzupus · #1 15-Aug-2003, 04:45

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: </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

PHP Code:


<? $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

JdS · #2 15-Aug-2003, 07:54

I have no idea what is value="<?=$r->sys_pk ?>" and the function query_db_trad().

But, you can try to hard-code the script temporarily by inserting a valid $ddir value inside the SQL string, e.g.:

PHP Code:


<?php
query_db_trad( "UPDATE `t_directories` SET `name` = '$name' WHERE `sys_pk` = 3" );
?>

If it works, then you know it's a HTML / form issue instead!

Also, always quote string values in SQL statements...

zuzupus · #3 15-Aug-2003, 08:00

Thanks JDK now it works fine with your recommended query

query_db_trad("UPDATE t_directories SET name=\"$name\" WHERE sys_pk = $ddir");

now it works fine

Regards

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
problem with php5 cgi installation	fab13	Apache Web Server Forum	3	19-Nov-2003 10:11
unwanted scrollbar problem	kelly001	Web Design Forum	3	24-Oct-2003 11:44
link problem [1][2]-----	zuzupus	MySQL / PHP Forum	0	16-Sep-2003 06:16
Google Update and DeepCrawl Alert	JdS	Search Engine Optimization Forum	24	16-Aug-2003 06:35
textarea width problem	zuzupus	Web Design Forum	2	23-Jul-2003 04:06