arrays, queries, birthdays, ...

[Stijn Goris]

hi all,

I have this problem that I cant solve.

I have created an agenda (http://28edegem.scoutnet.be/agenda.php) . The
agenda contains events and birthdays of the members. I query the events and
birthdays per month and sort them on date.
This method works fine for the events since they are all for the same year
(eg 2003) but doesnt work for the birthdays because someone born in
1980-06-23 will be sorted before someone born in 1876-06-05 . This is a big
problem because the person born on the fifth day wont be echo'ed . The
problem can be easily be solved by only requesting the month and day part of
the birthday. I'm not sure this is possible?

If the above doesnt seem to work I can always order the array myself. How
can I access a query array? I guess I can't use the fetch_row ?

kind regards
Stijn

[Pedro]

Stijn Goris wrote:
[...]

The
problem can be easily be solved by only requesting the month and day part of
the birthday. I'm not sure this is possible?

If the above doesnt seem to work I can always order the array myself. How
can I access a query array? I guess I can't use the fetch_row ?

Better to do it at the database side (for MySQL):

$sql = "select month(birthdate), dayofmonth(birthdate), name, address"
." from agenda"
." where public=1"
." order by 1, 2";

--
"Yes, I'm positive."
"Are you sure?"
"Help, somebody has stolen one of my electrons!"
Two atoms are talking:

[Kevin Thorpe]

Stijn Goris wrote:

hi all,

I have this problem that I cant solve.

I have created an agenda (http://28edegem.scoutnet.be/agenda.php) . The
agenda contains events and birthdays of the members. I query the events and
birthdays per month and sort them on date.
This method works fine for the events since they are all for the same year
(eg 2003) but doesnt work for the birthdays because someone born in
1980-06-23 will be sorted before someone born in 1876-06-05 . This is a big
problem because the person born on the fifth day wont be echo'ed . The
problem can be easily be solved by only requesting the month and day part of
the birthday. I'm not sure this is possible?

If the above doesnt seem to work I can always order the array myself. How
can I access a query array? I guess I can't use the fetch_row ?

order by dayofmonth(date)