DaniWeb Forum Index > Web Development > PHP

birthday script

Thread Solved

•

Join Date: Sep 2009

Posts: 201

Reputation: muralikalpana is an unknown quantity at this point

Solved Threads: 11

muralikalpana muralikalpana is offline

Offline

Posting Whiz in Training

birthday script

-1

Nov 23rd, 2009

hello,
i want to display names of upcoming birthdays whose between "today" to "end of every month". how to do this

Last edited by muralikalpana; Nov 23rd, 2009 at 3:51 am.

•

Join Date: Sep 2009

Posts: 201

Reputation: muralikalpana is an unknown quantity at this point

Solved Threads: 11

muralikalpana muralikalpana is offline

Offline

Posting Whiz in Training

Nov 23rd, 2009

•

Originally Posted by muralikalpana

hello,
i want to display names of upcoming birthdays whose between "today" to "end of every month". how to do this

how to retrive values from database

•

Join Date: Oct 2009

Posts: 185

Reputation: venkat0904 is an unknown quantity at this point

Solved Threads: 20

venkat0904 venkat0904 is offline

Offline

Junior Poster

-1

Nov 23rd, 2009

•

Originally Posted by muralikalpana

how to retrive values from database

assuming u have a field dob (with datatype as date) in user table this query can help u...

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$current_month = date(m);
 $current_day = date(d);
    $result = mysql_query("SELECT name FROM user WHERE month(dob) = $current_month AND day(dob) >= $current_day ")
$current_month = date(m);
 $current_day = date(d);
    $result = mysql_query("SELECT name FROM user WHERE month(dob) = $current_month AND day(dob) >= $current_day ")

Hope its clear..
cheers!!

Last edited by venkat0904; Nov 23rd, 2009 at 5:34 am.

Gimme reputation points if u find my post helpful.
use [code] tags wherever applicable
dont start a new thread unless u cant find the topic already on forum.
mark a thread "solved" as soon as u get a solution

•

Join Date: Sep 2009

Posts: 201

Reputation: muralikalpana is an unknown quantity at this point

Solved Threads: 11

muralikalpana muralikalpana is offline

Offline

Posting Whiz in Training

Nov 23rd, 2009

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND day(dateofbirth) >=' at line 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND day(dateofbirth) >=' at line 1

getting this error

•

Join Date: Dec 2008

Posts: 115

Reputation: urtrivedi is an unknown quantity at this point

Solved Threads: 16

urtrivedi

Offline

Junior Poster

Nov 23rd, 2009

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
    $result = mysql_query("SELECT name FROM user WHERE month(dob) = '$current_month' AND day(dob) >= '$current_day' ")
    $result = mysql_query("SELECT name FROM user WHERE month(dob) = '$current_month' AND day(dob) >= '$current_day' ")

•

Join Date: Oct 2009

Posts: 185

Reputation: venkat0904 is an unknown quantity at this point

Solved Threads: 20

venkat0904 venkat0904 is offline

Offline

Junior Poster

Nov 23rd, 2009

•

Originally Posted by urtrivedi

Help with Code Tags

PHP Syntax (Toggle Plain Text)
    $result = mysql_query("SELECT name FROM user WHERE month(dob) = '$current_month' AND day(dob) >= '$current_day' ")
$result = mysql_query("SELECT name FROM user WHERE month(dob) = '$current_month' AND day(dob) >= '$current_day' ")

yeah try that out... my bad... rightly deserve a negative point for that post

Actually u should alwayz save ur query in a variable and then execute it..
this way when u encounter an error , u can echo ur query statement and find out the source of error easily...
something like this..

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$query = "SELECT name FROM user WHERE month(dob) = ".$current_month." AND day(dob) >= ".$current_day;
$result = mysql_query($query);
$query = "SELECT name FROM user WHERE month(dob) = ".$current_month." AND day(dob) >= ".$current_day;
$result = mysql_query($query);

Last edited by venkat0904; Nov 23rd, 2009 at 7:52 am. Reason: improvising

•

Join Date: Sep 2009

Posts: 201

Reputation: muralikalpana is an unknown quantity at this point

Solved Threads: 11

muralikalpana muralikalpana is offline

Offline

Posting Whiz in Training

-1

Nov 23rd, 2009

•

Originally Posted by venkat0904

yeah try that out... my bad... rightly deserve a negative point for that post
Actually u should alwayz save ur query in a variable and then execute it..
this way when u encounter an error , u can echo ur query statement and find out the source of error easily...
something like this..
Help with Code Tags

PHP Syntax (Toggle Plain Text)
$query = "SELECT name FROM user WHERE month(dob) = ".$current_month." AND day(dob) >= ".$current_day;
$result = mysql_query($query);
$query = "SELECT name FROM user WHERE month(dob) = ".$current_month." AND day(dob) >= ".$current_day; $result = mysql_query($query);

how to fetch date as this format: (example: 2nd aug 1986) like this
how to format?

•

Join Date: Sep 2009

Posts: 201

Reputation: muralikalpana is an unknown quantity at this point

Solved Threads: 11

muralikalpana muralikalpana is offline

Offline

Posting Whiz in Training

-1

Nov 23rd, 2009

i want to display date format this (1989-03-09) as 9th mar 1989.
give an idea......how to format like this

•

Join Date: Oct 2009

Posts: 185

Reputation: venkat0904 is an unknown quantity at this point

Solved Threads: 20

venkat0904 venkat0904 is offline

Offline

Junior Poster

Nov 24th, 2009

•

Originally Posted by muralikalpana

i want to display date format this (1989-03-09) as 9th mar 1989.
give an idea......how to format like this

use this query..

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$query = "SELECT name, DATE_FORMAT(dob, '%D %b %Y') FROM user WHERE month(dob) = ".$current_month." AND day(dob) >= ".$current_day;
$query = "SELECT name, DATE_FORMAT(dob, '%D %b %Y') FROM user WHERE month(dob) = ".$current_month." AND day(dob) >= ".$current_day;