On Thu, Aug 15, 2002 at 01:12:59PM +0300, kale wrote:
> SELECT *, DISTINCT name FROM history ORDER date DESC, time DESC LIMIT 10
> but this not work. how can I do this?  I use a mysql server.

That's because your query string syntax is all messed up.

Put a mysql_error() call in your script after the mysql_query() call.  It 
will tell you what the error is.  

(Or, of course, you can execute the query directly from your MySQL client
command line.)

If you're unclear about what the error message is saying, read the MySQL 
manual on how to write SELECT statements.

               PHP classes that make web design easier
        SQL Solution  |   Layout Solution   |  Form Solution
    sqlsolution.info  | layoutsolution.info |  formsolution.info
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
 4015 7 Av #4AJ, Brooklyn NY     v: 718-854-0335     f: 718-854-0409

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to