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:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 10:57 AM
To: [EMAIL PROTECTED]
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.
    [EMAIL PROTECTED]




_________________________________________________________________
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



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to