Select month/year from MYSQL query

[skosterow]

Heya Gang -

I went to the site in my previous post,

http://www.mysql.com/doc/en/Date_and_time_functions.html

but i dont quite understand how this works. I need to extract a certain month and year. this is the code i am using:

my $dsn = "DBI:mysqlPP:tt_open:$DB::SERVER";
my $dbh = DBI->connect($dsn, $DB::USER, $DB:ASS);
my $sth = $dbh->prepare(qq{ SELECT number FROM open WHERE createby = '$STAFF::NAMES[$counter01]' and extract(month from createdate) = '$SELECT::MONTH' and extract(year from createdate) = 2003 });
$sth->execute();
while (($TT::NUMBER) = $sth->fetchrow_array())
{ $STAFF::OPEN = $STAFF::OPEN + 1; $TOTAL::OPEN = $TOTAL::OPEN + 1; }
$sth->finish();
$dbh->disconnect();

I'd prefer if you didnt give me code, but maybe point me somewhere, where there is a better description of how to do what i need..... that way i can get a better grasp on how MySQL does the select function.

Thanks in advanced.

- Scott

 

[sleipnir214]

I don't understand your question. What problem are you having?


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[skosterow]

Sleipnir214,

im looking to add one to $STAFF::OPEN when say the month in a datestamp is = 4 and the year is = 2003.

Sorry about the way i posed the question, I did try to look it up on the net. no luck.

;-)

 

[sleipnir214]

Where is it failing? What is your script doing or not doing when you run it? What errors are produced?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!