Ask a Question related to Macromedia Dynamic HTML, Design and Development.
-
thlokey #1
PHP Date Query
I'm trying to create a recordset where I query a date field in my database. I
can't figure the syntax. A little help here:
WHERE Category = ''News'' AND links.`Date` = ''2005-08-17''
I'd actually like it to query all information from 7 days ago forward.
Thanks - Tod
thlokey Guest
-
date query problem, date in variable
I am using the following query : $query_archief = "SELECT * FROM vacatures where dd_eind_plaatsing < $dd_eind_plaatsing_archief1" note:... -
More Date Query Problem
Hi, I have written the code below to return only data that are recorded this month: <cfquery name="getInfo" datasource="main_acc" dbtype="odbc">... -
Date Query
I am attempting to pull information from a database and the main criteria of how I retrieve the information in a date format. The startdate and... -
a date query question
I have this update query: UPDATE AccountsIpLogs SET LoggedIn = '0' I would like to add below WHERE statement but I don't know how to write it: ... -
Date query in ASP
ASP/Scripting newbie question here. I have an access database that I am writing ASP pages to query and return the results. The end user can put... -
rob::db #2 Re: PHP Date Query
I find the various time and date formats almost impossible to deal with
using proper MySQL date fields and stuff. I just stick to using UNIX
timestamps, and converting them to human readable formats when it comes to
writing to the screen.
thlokey wrote:> I'm trying to create a recordset where I query a date field in my
> database. I can't figure the syntax. A little help here:
>
> WHERE Category = ''News'' AND links.`Date` = ''2005-08-17''
>
> I'd actually like it to query all information from 7 days ago
> forward.
>
> Thanks - Tod
rob::db Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
