On Mon, 2002-11-18 at 17:01, OYNot wrote: [snip] > //The following was supposed to create a count, by day, of the unique ip > addresses.
You can use the date_format() to convert timestamps and dates into whatever format you want. I think you only need a single query like: select ip, date_format( dateIn, '%d.%m-%Y' ) day, count(*) from log group by day, ip; == Martin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php