Re: select distinct mysql

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. http://www.php.net/manual/en/function.mysql-error.php. (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. http://www.mysql.com/doc/en/SELECT.html --Dan -- 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