Hi Jess
Have you tried SELECT DISTINCT
not sure if 'select distinct *' will work but if doesn't 'select
distinct userlastname,userfirstname' will
hope this helps
Steve Davies
Hunter, Jess wrote:
Using PHP as the front end I am creating a form with a dropdown box that
displays information fro
Perhas you want SELECT DISTINCT ?
http://www.mysql.com/doc/en/SELECT.html
Hope that helps,
Ken
- Original Message -
From: "Hunter, Jess" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 12, 2003 10:47 AM
Subject: How to keep multiple instances o
Using PHP as the front end I am creating a form with a dropdown box that
displays information from one table to be inserted into another table.
That's PHP and I have gotten that part down with no issue.
However, in the table a person could be listed multiple times and I only
want a user to be list