How can I get mySQL to group stuff by the day? my date coloumn is a UNIX
timestamp.
--
JJ Harrison
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Fixed it by doing multiple querys
--
JJ Harrison
[EMAIL PROTECTED]
Noodle Snacks [EMAIL PROTECTED] wrote in message
news:20021019113342.17226.qmail;pb1.pair.com...
Although my query returns the date of the day that had the highest number
of
records inserted.
It outputs the total number
Although my query returns the date of the day that had the highest number of
records inserted.
It outputs the total number of records in the table..
Can someone with more experience in SQL help me only count the number of
records inserted on the day with the highest number of records?
BTW the
$7c02a8c0;coconut...
Well, for one thing, EXTRACT() is for MySQL timestamps, not unix
timestamps.
---John Holmes...
-Original Message-
From: Noodle Snacks [mailto:webmaster;tececo.com]
Sent: Saturday, October 19, 2002 7:36 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] It counts
I have table A with an auto increment coloumn called tid. during the same
query I need to get that value and stick it in a related record in anouther
table.
I have two doubts.
A: What is the way to do a multitable insert? guess is: INSERT INTO
table(fields) VALUES (fields), table1(fields)
I can get the previous insert auto-increment id via mysql_insert_id(). it
will solve my problem. but if you know a soloution that will work in one
query please share it with me/everyone!
--
JJ Harrison
[EMAIL PROTECTED]
Noodle Snacks [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]"
