Again Select then update
| From: | Jen Downey | Date: | Sun, 24 Mar 2002 02:17:43 +0000 |
| Subject: | Again Select then update | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17862@lists.php.net to get a copy of this message | ||
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"])or die("Error: ".mysql_error());
When the script is run I receive this error and I am not understanding why,
can some point out why?
your name is Test
Error: Unknown column 'Test' in 'field list'
TIA
Jen