Display users birthday?

[lovephp]

friend i store dob as 12/17/1984 in my table now how do i go on geting users birthday if today is 12/16 how could i display only the mm/dd from table?

 

i tried

 

 

$today = date("m-d");
$result = mysql_query("SELECT * FROM members WHERE dob = '".$today."'");

 

but not happening

[Barand]

if your date is stored as 12/17/2014 why would you expect 12-17 to find a match?

 

try finding those that begin with "12/17"

$today = date("m/d");
$result = mysql_query("SELECT * FROM members WHERE dob LIKE '$today%'");

Dates should be stored in yyyy-mm-dd format in DATE type fields for maximum functionality, you cannot even sort dates like yours correctly.

[lovephp]

not working it only display just one result

 

 

$today = date("m/d");
$res = mysql_query("SELECT * FROM members WHERE dob LIKE '$today%'");
$rw = mysql_fetch_array($res);
echo $rw['dob'];
echo '<br/>';
echo $rw['name'];
echo '<br/>';
echo $today;

[Barand]

If you only fetch one result then that is all that will be displayed. Use a while loop to loop through the returned records

$today = date("m/d");
$res = mysql_query("SELECT * FROM members WHERE dob LIKE '$today%'");
while ($rw = mysql_fetch_array($res))
{
    echo "{$rw['dob']}<br/>{$rw['name']}<br/>$today<br/><br/>";
}

[lovephp]

oops i missed that thats alot bro cheers