Re: update db
| From: | Richard Lynch | Date: | Fri, 26 Jan 2001 23:56:06 +0000 |
| Subject: | Re: update db | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-36932@lists.php.net to get a copy of this message | ||
It's just like a SELECT, only you send an UPDATE query.
$query = "select * from people";
$people = mysql_query($query) or die(mysql_error());
.
.
.
$query = "update people set name = 'Fred' where lastname =
'Flintstone'";
mysql_query($query) or die(mysql_error());
You can send *ANY* query to the database, not just SELECT.
UPDATE, INPUT, DROP, ALTER TABLE, whatever you can dream up that your
database will allow you to do.
--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
----- Original Message -----
From: Kurth Bemis <kurth@usaexpress.net>
Newsgroups: php.general
Sent: Friday, January 26, 2001 10:58 AM
Subject: [PHP] update db
> whats the php function that will let me update a db field? I've been
> looking at the manual but there seems to be no mention of it.
>
> ~kurth
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>