One possible reason why it does not work is that the DAY() function does not exist.
Use DATE_FORMAT() instead. Ignatius _________________________ ----- Original Message ----- From: "Disko_kex" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 10:47 AM Subject: [PHP-WIN] MySQL question Hi SELECT RegDate FROM table WHERE month(RegDate) = '10' // this is working SELECT RegDate FROM table WHERE day(RegDate) = '2' // why isnīt this working? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
