Display only first of mutiple matches

	Home Register Search Help Login

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Display only first of mutiple matches

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> Display only first of mutiple matches

Page: [1]


chadb Posts: 501 From: Kansas Status: offline	Display only first of mutiple matches - 4/28/2009 13:42:36 I have a database that a field employee, I have the ordering by employee, but how do I show only the first-of when there are mutiple matches, so if I have "bob" 8 times, I only want to display it 1 time. Chad


TexasWebDevelopers Posts: 722 Joined: 2/22/2002 From: Dallas, TX Status: offline	RE: Display only first of mutiple matches - 4/28/2009 14:24:36 To limit multiple names in the same field use DISTINCT in the SQL statement. http://www.texaswebdevelopers.com/examples/sql_intro.asp#distinct _____________________________ Follow us on TWITTER (in reply to chadb)