RE: [PHP-DB] DEALING WITH RETRIEVING AND WRITING DATE VALUE FROM/TO TABLE
| From: | Cal Evans | Date: | Wed, 09 Oct 2002 19:15:20 +0000 |
| Subject: | RE: [PHP-DB] DEALING WITH RETRIEVING AND WRITING DATE VALUE FROM/TO TABLE | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22297@lists.php.net to get a copy of this message | ||
I agree with John, this is a REAL basic thing. Please read over the relevant
portions of the manual.
I'll give you a quick sample though.
// selecting data based on a date
$sql = "select fieldOne, fieldTwo, fieldThree, myDateField from myTable
where myDate>'2002-10-09';";
$rs = mysql_query($sql);
// writing to a date field
$sql = "update myTable set myDateField='2002-10-09' where myTableID=5;";
$rs = mysql_query($sql);
HTH,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-----Original Message-----
From: Robert Leahong [mailto:rleahong@hotmail.com]
Sent: Wednesday, October 09, 2002 10:57 AM
To: php-db@lists.php.net
Subject: [PHP-DB] DEALING WITH RETRIEVING AND WRITING DATE VALUE FROM/TO
TABLE
I need to know how to retrieve a date field from a database
table using MYSQL_DB_QUERY to create recordset. As well as
writing a Date Variable to a table using MYSQL_QUERY .
YOURS Truly,
Robert Leahong.
rleahong@hotmail.com
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php