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());


Thanks again
Jen



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to