RE: [PHP-DB] Need help replacing one record
| From: | Hutchins, Richard | Date: | Fri, 09 Jan 2004 18:35:53 +0000 |
| Subject: | RE: [PHP-DB] Need help replacing one record | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32351@lists.php.net to get a copy of this message | ||
If I understand your question correctly, an UPDATE query should be all you
need.
UPDATE tablename SET columname='value' WHERE someid='somenum';
I'm assuming you don't have the MySQL doc. Check mysql.com for the docs for
your version of the server.
Rich Hutchins, CIW Professional
Sr. Technical Writing Administrator
Getinge USA
1777 E. Henrietta Rd.
Rochester NY 14623
585-272-5072
www.getingeusa.com
> -----Original Message-----
> From: Jeroen Wasteels [mailto:jeroenwasteels@yahoo.Com]
> Sent: Friday, January 09, 2004 1:24 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Need help replacing one record
>
>
> Is there a way to change the information in one record of a
> database, for
> example the password, without having to open the entire row,
> delete it, and
> then add it with $row_data[name] and all and the $newpass as changed
> password?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>