Hi Bill, No it isn't the latest it is updated with the quotes and slashes in the script. I have found that even if I put my name Jen as $update it still wont update the table.
$update = "Jen" There is no error and the script acts like it work fine without updating. I just 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 -0800, Jen Downey wrote: > > 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 the > > browser but it simply will not update the table. > > > > $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"])or die("Error: ".mysql_error()); > > > > Is this your latest code? You still don't have quotes around $update, if so. > > Nothing returned in the .mysql_error()? > > Can you run the query by hand? > > Bill -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php