The table has about 80 fields. I would something like: <select *, distinct Location from hotels order by Name> (this one creates a MySQL error) to one full row for every Location. I suppose I have to do it with a php script. (with limit 1 to the second query)
You can see it at http://www.macedonia-hotels.gr Makis > -----Original Message----- > From: Jay Blanchard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 02, 2002 6:59 PM > To: 'savaidis'; [EMAIL PROTECTED] > Subject: RE: get one <name> for each row > > > [snip from mysql list message] > I tried > <select distinct Location from hotels1 order by Location> > and worked. > But how can I show all fields of the rows? > It doesn't accept any field before <distinct> and shows every row after > <distinct> (if I put <select distinct Location, Name ...> ) > [/snip] > > Can we see your table? Can you also write out what you expect the > results to > be? > > Thanks! > > Jay Blanchard > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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