I have the thing returning the date as long as the date format is "m/d" in
the table with a seperate year column.
Here's the table:
mysql> select * from Cinfo;
+-----+--------+----------+-------+-------+
| Cid | Fname | Lname | Bday | Byear |
+-----+--------+----------+-------+-------+
| 1 | Lars | Larsen | 03/02 | 1960 |
| 2 | Larry | Loophole | 03/02 | 1950 |
| 3 | Fuzzy | Wimp | 03/02 | 1990 |
| 4 | Willy | Warp | 03/03 | 1960 |
| 5 | Harry | Toes | 03/03 | 1998 |
| 6 | Jiminy | Cricket | 03/04 | 1889 |
+-----+--------+----------+-------+-------+
6 rows in set (0.00 sec)
Here's the code, I would welcome comments or improvements.
$db = mysql_connect("localhost", "root");
$Date = date("m/d");
mysql_select_db("customers",$db);
$result = mysql_query("SELECT * FROM Cinfo WHERE Bday = '$Date'");
The result is sent to a table and to my surprise actually works...
--
Ken Thompson, North West Antique Autos
Payette, Idaho
Email: [EMAIL PROTECTED]
http://www.nwaa.com
Sales and brokering of antique autos and parts.
Linux- Coming Soon To A Desktop Near You
Registered Linux User #183936
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
