Getting Birthdays Listed

[spighita]

Hello:
I have a database where the birthdays are listed. I would like first, a condition where only if someone's birthday is today then the list would appear.

I get this
Example 1
Today's birthday is a
Today's birthday is b
Today's birthday is c
etc

I would like
Example 2
Today's birthday is
a-d
b-e
c- f

So if there isn't any birthdays nothing would appear, my code will list like example 1, how can I go with example 2.

Thanks in advance for anyone who helps.

I

[HalfaBee]

You need something like this

$result=mysql_query( "SELECT * from table where birthdate=now()" );
if( ($rows=mysql_num_rows( $result ))!=0 )
{
    echo "Todays birthday people are";
    while( $row[]=mysql_fetch_array($result) );
    $tablelen = ceil( $rows/4 );
    for( $j=0;$j<$tablelen;$j++ )
        for( $i=$j;$i<$rows;$i+=$tablelen )
            echo $row['name']." ";
}

HalfaBee

[spighita]

Thanks for the code, It works ok but the array won't look like
a - b
c - d
e - f

or similar to
a-d
b-e
c-f

[HalfaBee]

At 4:00am I realised I had made a mistake, but the internet was stuffing up down here today.

$result=mysql_query( "SELECT * from table where birthdate=now()" ); 
if( ($rows=mysql_num_rows( $result ))!=0 ) 
{ 
    echo "Todays birthday people are<br>"; 
    while( $row[]=mysql_fetch_array($result) ); 
    $tablelen = ceil( $rows/4 ); 
    for( $j=0;$j<$tablelen;$j++ ) 
    {
        for( $i=$j;$i<$rows;$i+=$tablelen ) 
            echo $row[$i]['name']." "; 
        echo "<br>";
    }
}

HalfaBee