Encerrado

Convert YYYY-MM to month year

Hi,

I am storing articles in a mySQL table. The table has a "created" field to show when the article was written. The created field is of datatype date (format YYYY-MM-DD).

I want to retrieve all articles and store them under their respective created dates in month year format, i.e.

January 2000

article 1

article 2

etc.

February 2000

article 3

article 4

etc.

I have managed to do this but only numerically, i.e.

01-2000

article 1

article 2

etc.

02-2000

article 3

article 4

etc.

I want to convert the month digit to its full text equivalent, i.e. "01" to "January" and "02" to February.

I came close on several occasions, I think, using date() and strtotime() etc. but ultimately, no luck.

I attach a file of where I am at the moment. Please note, I'm only interested in the month and year, NOT the day.

The change is purely aesthetic, e.g. it's not used in the SQL statement, but I would be interested to learn how to do it.

Thanks.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

PHP 4.0

mySQL

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: the month of january, month of january, learn to code, learn sql, january is the month of, january is month, i want to learn php, how to learn how to code, how to learn code, learn to code c, year, mm, article year, sql retrieve table, mysql convert text, numerically, table month php, engineering year, php form convert, february month, year articles, convert statement file, datatype, convert sql code, month complete

Acerca do Empregador:
( 127 comentários ) United Kingdom

ID do Projeto: #2984836

46 freelancers are bidding on average $15 for this job

yankleberdemoura

See private message.

$17 USD in 2 dias
(146 Comentários)
6.6
ekam

See private message.

$4.25 USD in 2 dias
(109 Comentários)
5.7
scalaccio

See private message.

$8.5 USD in 2 dias
(27 Comentários)
5.2
cdmanvw

See private message.

$4.25 USD in 2 dias
(43 Comentários)
5.0
Uplink03

See private message.

$8.5 USD in 2 dias
(68 Comentários)
4.8
antosgroup

See private message.

$4.25 USD in 2 dias
(27 Comentários)
4.6
stevelb22

See private message.

$6.8 USD in 2 dias
(60 Comentários)
4.5
hajjs

See private message.

$3.4 USD in 2 dias
(17 Comentários)
4.3
royalsoftvw

See private message.

$4.25 USD in 2 dias
(20 Comentários)
4.2
vw406117vw

See private message.

$8.5 USD in 2 dias
(12 Comentários)
3.8
chorlya

See private message.

$17 USD in 2 dias
(11 Comentários)
3.6
mach3vw

See private message.

$6.8 USD in 2 dias
(24 Comentários)
3.6
andrewmkiller

See private message.

$4.25 USD in 2 dias
(24 Comentários)
3.5
avcware

See private message.

$4.25 USD in 2 dias
(4 Comentários)
3.4
felenkavw

See private message.

$4.25 USD in 2 dias
(26 Comentários)
3.4
siddhh

See private message.

$17 USD in 2 dias
(6 Comentários)
3.4
alekseytvw

See private message.

$8.5 USD in 2 dias
(8 Comentários)
3.3
micahleevw

See private message.

$21.25 USD in 2 dias
(11 Comentários)
3.4
leossh

See private message.

$42.5 USD in 2 dias
(12 Comentários)
3.2
superpedro

See private message.

$42.5 USD in 2 dias
(6 Comentários)
3.7