Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "localhost";
- $user = "root";
- $pass = "";
- $db = "alumni";
- $connect = mysql_connect($host, $user, $pass) or die ("Unable to connect to host");
- //Select Database
- mysql_select_db($db) or die ("Unable to connect to database");
- $today = date("y"); // get today's date (month and day only!)
- $sql = "select * from users where bday='".$today."'";
- $list = mysql_query($sql);
- while ($lst = mysql_fetch_array($list))
- {
- echo ("Happy birthday " . $lst['username'] . "!<br>");
- }
- //$exp_date = "2012-10-12";
- //todays_date = date("Y-m-d");
- //$today = strtotime($todays_date);
- //$expiration_date = strtotime($exp_date);
- //if ($expiration_date == $today) {
- // echo "equal";
- //} else {
- //echo "no";
- //}
- ?>
Add Comment
Please, Sign In to add comment