Re: dynamic drop down list from the date field filtered to uniquemonths

[macca]

You don't have to use DISTINCT on the full date, for example to get
the distinct months use something like:

SELECT DISTINCT MONTHNAME(date_field) AS Months
or a PHP solution may use the array_unique() function on your db
result set

[jsd219]

On Jun 8, 5:20 am, macca <[e-mail]:

You don't have to use DISTINCT on the full date, for example to get
the distinct months use something like:

SELECT DISTINCT MONTHNAME(date_field) AS Months

or a PHP solution may use the array_unique() function on your db
result set

Thank you i will give it a shot.

God bless
jsd219

[jsd219]

That worked, thank you very much...i do have one more issue to deal
with now. the value of the month is August or July. how would i go
about converting that back to an integer. ie 06, 07? I tried changing
the DISTINCT from MONTHNAME to MONTH and that gives me the integer but
then i need a variable to change that integer into the Month Name.
Either way i go about it i need an additional variable that converts
my query value to the opposite of what i pulled. I hope this makes
sense. :)

God bless
jsd219

[Jerry Stuckle]

jsd219 wrote:

That worked, thank you very much...i do have one more issue to deal
with now. the value of the month is August or July. how would i go
about converting that back to an integer. ie 06, 07? I tried changing
the DISTINCT from MONTHNAME to MONTH and that gives me the integer but
then i need a variable to change that integer into the Month Name.
Either way i go about it i need an additional variable that converts
my query value to the opposite of what i pulled. I hope this makes
sense. :)

God bless
jsd219

These are SQL questions, and should be asked in the appropriate database
newsgroup, i.e. comp.databases.mysql for MySQL.

You'll get much better answers there - that's where the database experts
hang out.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[macca]

You should look up date() in the manual, for example:

<?php

echo date('F',strtotime('01')); //Prints January

echo date('m',strtotime('January')); //Prints 01

?>

[macca]

It's not hard to convert the monthname to month:

echo date('m',strtotime('March')); //Prints 03

echo date('m',strtotime('august')); //Prints 08

[Jerry Stuckle]

macca wrote:

It's not hard to convert the monthname to month:

echo date('m',strtotime('March')); //Prints 03

echo date('m',strtotime('august')); //Prints 08

And there are even better ways to do it in SQL - which is why I
recommended he try a database newsgroup.

Ask in the best group and you get the best answers.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[jsd219]

Thank you and Yes Jerry I agree this is now a database question
however when I originally posted it I was under the impression that I
could not do this via MySql but needed to do it through php. I will go
over to the database group and see about an easier way to do it via
MySql.

Thanks again Macca and Jerry

God bless
jsd219