August 18th, 2004, 05:03 AM
|
 |
Command Line Warrior
|
|
Join Date: Aug 2004
Location: Sector ZZ9 Plural Z Alpha
|
|
ok, say your three date fields are labelled day, month and year, I'd use something like the following, assuming your DB is MySQL:
PHP Code:
$date = $_POST['year'].str_pad($_POST['month'], 2, '0', STR_PAD_LEFT).str_pad($_POST['day'], 2, '0', STR_PAD_LEFT);
$query = "SELECT Name FROM People WHERE Birthday='".$date."' ORDER BY Name";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0)
{
echo "<div>\nThe following people have their birthday on ".$_POST['day']."-".$_POST['month']."-".$_POST['year'].":\n<ul>\n";
while($temp = mysql_fetch_array($result))
echo "<li>".$temp['Name']."</li>\n";
echo "</ul>\n</div>\n";
}
else
echo "<div>\nNo people have their birthday on ".$_POST['day']."-".$_POST['month']."-".$_POST['year']."\n</div>\n";
Hope this helps
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Absolutely worked
Linear Mode
