PHP/MySQL Related

Anon

I want to display only those records from my database which are specific to that day

If u have the answer for the same than please help me

Sonia

Anon

For today:

SELECT * FROM your_table WHERE date_column = NOW();

For a given day:

SELECT * FROM your_table WHERE date_column = '2000-11-1';

This depends on what kind of column your date is stored in. Give some more info if these don't answer your question....

---John Holmes...

Anon

hi John

Thankyou for your reply but my problem is still unsolved. My column of date field is varchar and it is taking the date in the following format

DD/MM/YYYY

Please help if u can

Sonia

Anon

That's what you get for going around the system. Why do you think they have a date data type in MySQL? So you don't have to use varchar...

With a varchar field, it's just a string, so you'll have to do a bunch of substr stuff to figure out the day and month and all that crud....there's no easy way to do it like there would be if you just make it a date column..

---John Holmes...

Anon

i know we have a date column in mysql but this database is not created by me so that's whay the problem and also i cant change the date from varchar to date field as it has 500 records and all records will be effected by doing this.

so help me finding a way out

thankx
Sonia

Anon

SELECT * FROM your_table WHERE date_column = DATE_FORMAT(NOW(),'%d/%m/%Y');

Try that...

---John Holmes...