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
