[PHP] Re: Retrieve specific data from MySQL

2004-02-02 Thread Matt Hedges
Thanks, ya'll! Got it working. "Matt Hedges" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > I have a basic question I can't figure out. > > My site lets people enter in their information... I now want to be able for > a user to search the database. For example, enter i

[PHP] Re: Retrieve specific data from MySQL

2004-02-02 Thread Jochem Maas
its not clear to me what exactly you are asking but it sounds like you would do well to read up on some MySQL syntax - specifically 'JOIN' syntax and 'ORDER BY' syntax. --- if you mean 'Smith' should match 'Smith', 'Smiths' & 'Smithson' then use the wildcard syntax (e.g LIKE '%Smith%' )

Re: [PHP] Re: Retrieve specific data from MySQL

2004-02-02 Thread John Nichel
Matt Hedges wrote: Thank you for your replies... I have it showing the last name... but what I can't figure out is how for it to reference to the whole entry. So, for example, when someone enters to search for the last name "Smith," all the "Smiths" are pulled up, sorted by first name and linked

[PHP] Re: Retrieve specific data from MySQL

2004-02-02 Thread Matt Hedges
Thank you for your replies... I have it showing the last name... but what I can't figure out is how for it to reference to the whole entry. So, for example, when someone enters to search for the last name "Smith," all the "Smiths" are pulled up, sorted by first name and linked by id. How do I do