php3-list | 2000051

RE: [PHP3] "order by" Question From: Craig Vincent (webmaster <email protected>)
Date: 05/12/00

<snip>
I have a MySQL table with some colums, but two of them are "Date" and the
other one "Time".
Now I want to make a selection order by Date, but then I want the result to
be order by Time too.
</snip>

Why not have a DATETIME column in the MySQL table instead? If you did that
then you only need one ORDER by and it'll be a faster sort.

Sincerely,

Craig Vincent 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>