Hi guys, I was wondering if anyone knew of a paramter that can be put on the end of a select statement when querying a table which only pulled out one unique record based on a field. I.e If i had a drink database and in it were 10 cokes 10 fantas 10 pepsi's what select statement would i need to pull out 1 coke,1 fanta,1 pepsi . Thanks for your help, a virtual beer to whoever answers my question :)
Andrew Wilson Technical Support Netway Networks 8920-8877 Netway Networks Pty Ltd (T) 8920 8877 (F) 8920 8866 --------------------------------------------------------------------- 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