[PHP-DB] Again Select then update

2002-03-23 Thread Jen Downey
Hi all! $query = "SELECT name FROM users WHERE uid={$session["uid"]}"; $ret = mysql_query($query); while(list($name) = mysql_fetch_row($ret)) print ("your name is $name"); $update = "$name"; $query_update["name"] = "UPDATE my_items SET name = $update"; $result = mysql_query($query_update["name"

[PHP-DB] Re: Again Select then update

2002-03-23 Thread Jen Downey
Hi all again! As Bill Morrow stated (in a private e-mail) I needed to use SET name = \"$update\""; instead of SET name = $update"; It has stopped giving the error but it isn't updating the table. Am I doing something wrong? line 4 shows print("your name is $name"); The user name is printed to th

Re: [PHP-DB] Re: Again Select then update

2002-03-24 Thread Jen Downey
did a test.php script and ran it. It will print the user name but still wont update the table. This has me totally stumped. Thanks Jen "Bill Morrow" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Sat, Mar 23, 2002 at 11:46:36PM