RE: [PHP-WIN] PHP & MySQL problems, updating database..
| From: | brother | Date: | Thu, 17 Jan 2002 18:28:03 +0000 |
| Subject: | RE: [PHP-WIN] PHP & MySQL problems, updating database.. | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-11491@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Hawk [mailto:hwk@barrysworld.com]
>
> I might be missing some line or maybe it's just because I'm a
> newbie or
> something.. ;D
> anyway.. I use something similiar to this
> $query = "UPDATE users SET email='$email'"; // and so on..
> $result = mysql_query($query) or die ("blabla");
Well if this codesnippet is what you used then (maybe) I see the problem.
$query = "UPDATE users SET email='$email' WHERE something=something";
Even though the uppdate syntax don't req. an WHERE statement it seems to fit
better in this case...
http://www.mysql.com/doc/U/P/UPDATE.html
The replace syntax may also give you some help in the problem solving.
http://www.mysql.com/doc/R/E/REPLACE.html
GL
/brother