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" <disko_kex@swedish-mushroom.com> To: <php-windows@lists.php.net> Sent: Monday, September 22, 2003 10:47 AM Subject: 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
