Birthday Script?

Clenard

Hi everyone,

I'm trying to create a Birthday Script on my site and so far I'm having no luck. All I'm trying to do is create a query that shows todays birthdays - but I would rather try to get the upcoming birthdays for the month.

My first attempt was something like:

$bday = "SELECT `month`, `day` FROM `user` ORDER BY CURDATE()";

$result = mysql_query($bday);

$Members = '';
while($row = mysql_fetch_row($result, MYSQL_ASSOC)) 
{ 
$Members .= $row["user"] . '<br>'; 
}

But for some reason I couldn't even get any response. I left the connection info out - I know it's connecting but my query is wrong.

My DB fields are:

DAY
MONTH
YEAR

these are located in USER

I'm very rusty, as you can see and I'm a little confused about how to get this info... any help would be greatly appreciated!

Again, I'm trying to get the birthdays for this month or even the next 2 weeks?

I've also tried:

$birth = date("m");

$bday = "SELECT * FROM `user` WHERE `month` = '.$birth.'";

$result = mysql_query($bday);

$Members = '';
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
{ 
$Members .= $row["user"] . '<br>'; 
}

echo 'Upcoming Birthdays';
echo $Members;

bogu

$sql = "SELECT `month`, `day` FROM `user` ";
$sql.= "WHERE `month` = ".date('n')." AND `day`>=".date('j')." ";
$sql.= "ORDER BY `month`, `day` ASC";

Clenard

Hey thanks Bogu! Although it didn't pull the info I needed it did help a little. I went to php.net and sought out the date info for this and came to this:

$sql = "SELECT `month`, `day` FROM `user` ";
$sql.= "WHERE `month` = ".date('m')." AND `day` >= ".date('d')." ";
$sql.= "ORDER BY `month`, `day` ASC"; 

$result = mysql_query($sql); 
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
{ 
	$Members .= ''.uimage($row['user'],"50",8,"class=\"pic5\" onmouseover=\"this.className='pic4';\" onmouseout=\"this.className='pic5';\"").''."\n";
}

I tried to just "select * from user where user = 'myname'"; and it pulled info up.

The reason I changed the query was because the Fields are 2 digits. I'm not familiar with everything the query is doing either. Is it pulling info from the DB to where all users with birthdays in this month will be brought up?

Thanks alot for the help!

Clenard

up... anymore help would be appreciated 🙂