Oh sure... Use logic!!!
I am using a MySQL database that has 4 columns, right now, they are
all set to VARCHAR since I was getting errors trying to make them date
fields. The column names are "vendor," "edate," "cdate," and "fname."
I want to pull all entries in the database where "cdate"
On Sun, 4 Aug 2002 17:42:17 +0200
Pierre-Alain Joye <[EMAIL PROTECTED]> wrote:
> On Sun, 4 Aug 2002 17:30:31 +0200
> "John Fishworld" <[EMAIL PROTECTED]> wrote:
> For a specific day, here the current day
WHERE DAYOFMONTH(t_event_date)=DAYOFMONTH(NOW()) AND MONTH(t_event_date)=MONTH(NOW())
if yo
On Sun, 4 Aug 2002 17:30:31 +0200
"John Fishworld" <[EMAIL PROTECTED]> wrote:
Why not simply does the where clause like :
for a whole month, here is july:
WHERE YEAR(t_event_date)='2002' AND MONTH(t_event_date)='7'
For a specific day, here the current day
WHERE t_event_date=NOW()
That means yo
> I thought I had this working, but it seems unfortunately not !!!
>
> I'm trying to list events for each month and my select query is as follows
>
> SELECT DISTINCT t_city_name,t_city_id_city FROM
> t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city =
> t_zipcodecity_id_city) AND (t_
maybe use a for loop and mail command.
should work
"Unknown Sender" <[EMAIL PROTECTED]> wrote in message
002701c23924$da9b1e40$539f4dd5@administrator">news:002701c23924$da9b1e40$539f4dd5@administrator...
Sorry to be a little bit off topic.
I need a tool or script in PHP, that will automaticaly s
On Sunday 04 August 2002 11:33, Chase Knott wrote:
> I am a newbie. There, I said it! *gryn*
>
> Maybe someone here can help me out... I am trying to figure out how to
> select a range of dates from my table to be used in a dynamic page. I
> know it is something simple, but I just can't seem t
