receiving date elements from Access
| From: | Jan Bro | Date: | Sun, 09 Mar 2003 21:42:38 +0000 |
| Subject: | receiving date elements from Access | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26208@lists.php.net to get a copy of this message | ||
Hi,
i've posted this in the general list, but I've got no answer. Well I'm still
hoping there is one ;-)
I've got the following code:
$datum_beginn="2002-12-12";
$datensatz=odbc_exec($db_connection,"select * from Termin where Datumsfeld
>'#$datum_beginn#'");
I get an error message that data in criteria doesn't match. (free
translation)
The error def. lays in Datumsfeld >'#$datum_beginn#'. How do I get a list of
all entries with a
date that lay behind a certain date? I'd prefer to let the database do the
job for me, rather than
pulling everything out and get the relevant data with php.
The field Datumsfeld is a date field with the syntax DD.MM.YYYY (German way)
thx
Jan