pls! help me.

[Anon]

i was in a difficult condition to splite the date value retrieved from mysql database.
i have to retrieve the data from a table according to a specific year.
I am a beginner to php.
Kindly help e
Thanks

[Anon]

A little more information please.

-Surojit

[kailien]

if ( !isset($yyyy) )
{
$yyyy = 2000; //if not set, it is year 2000
}

$sql = "select * from table_name where year(date_column_name) = '$yyyy');

Kai

[benkhamkoshy]

Sir,
Thanx for ur help .
I tried with ur suggestion and i got the
apt solution within half an hour.
I really grateful to u
By KOSHY

Kai wrote:

if ( !isset($yyyy) )
{
$yyyy = 2000; //if not set, it is year 2000
}

$sql = "select * from table_name where year(date_column_name) = '$yyyy');

Kai