Expiry date

Teaky

Hello there,

I have a job, which asks me to display links on a web page, as long as their expiry date is valid. Basically I need a piece of code that…

1) Grabs the Expiry date from the column of the table.
2) It then compares it to today’s date.
3) Only display the link if it hasn’t reached its expiry date.

I’ll be grateful for anyone who helps. 😃

Teaky

cahva

SELECT link FROM table WHERE link_expirydate <= CURDATE()

Use only < if you dont want links from the exact expirydate

Teaky

Thanks dude,

But the SQL statement doesn't work.

Well......the " CURDATE()" value. Do you have to declare this or something?! 🙁

Teaky

Hmm.......does anybode else have any ideas?! 🙁

HalfaBee

Maybe more information is needed.
Like table or col formats.

Teaky

Okay..............

Table name ‘message’

Column name ‘exp_date’
Column format ‘Date’

bad76

Hi Teaky
just try to use NOW() instead of CURDATE()

I hope this help you

Teaky

Sorry dude, that didn’t work either.

The way I did it was…

$today = date("d/m/y");

SELECT link FROM table WHERE exp_date <= $today

However this only compares the first values i.e. the days and it ignores everything else.

Any advice?!

bad76

mmm
try $today = date("Y-m-d"); instead...

Teaky

Nope didn't work 🙁

Weedpacket

Well,

$today = date("d/m/y");

SELECT link FROM table WHERE exp_date <= $today

Isn't the same as

try to use NOW() instead of CURDATE()

So are you saying that

SELECT WhateverYou'reTryingToSelect FROM message WHERE exp_date <= NOW()

didn't work?

HalfaBee

Doesn't mysql store 'date' types as yyyy-mm-dd ?

$today = date("Y-m-d'");

SELECT link FROM table WHERE exp_date <= '$today'

might work

Teaky

OOps.....maybe I should have warned that I am using SQL Server!!!

bad76

ihihihi
it's a little particular eeeeh? ahahah

So you have to use GETDATE() function!!! 🙂

I hope this works... let's know...

see youuu

(SELECT WhateverYou'reTryingToSelect FROM message WHERE exp_date <= GETDATE())

Teaky

OMg.......I did a bit a searching .....I found you have to use GETDATE() function!!! 😃

I found this out about two minutes before bad76 posted his message!!! LOL

Oh well........cheers dude, it works 🙂

Man......should have mentioned about SQL Server earlier!!! 🙁

Thanks everyone!!!

bad76

nice eheheh

Ghghgh 😃

it's all good that ends good... :-P
bye bye