RE: [PHP-DB] DEALING WITH RETRIEVING AND WRITING DATE VALUE FROM/TO TABLE

2002-10-09 Thread Cal Evans
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)

Re: [PHP-DB] DEALING WITH RETRIEVING AND WRITING DATE VALUE FROM/TO TABLE

2002-10-09 Thread 1LT John W. Holmes
> 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 . For one, don't use mysql_db_query(), it's depreciated. You'd use mysql_query() for both instances and m