Re: Re: Again Select then update

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