On Fri, Apr 13, 2001 at 02:23:50PM -0400, Doug Semig wrote:

> Have you thought about normalizing your data model?  It could make your
> task a lot easier.

I have normalized my table structure this is just a practice model i m trying
I want that the search should be on username whereby first i search table1
,then table2,table3 using table4 and displaying unique record 
> 
> At 11:33 PM 4/13/01 +0530, Sharmad Naik wrote:
> >I have three table called table1, table2, table3 all having fields like:
> >table1 contain id and username and id referencing table4
> >table2 contains id and parallel_username and id referencing table4
> >table3 contains id and other_username   and id referencing table4
> >table4 is the main table containing id as primary key
> >I want to develop a search engine which shows unique record after searching
> >all the three table but shouldn't contain multiple answers for same SEARCH
> for
> >username
> >Pls help me,
> >
> >-Regards

-Regards
-- 
The secret of the universe is @*&í!'ñ^#+ NO CARRIER
__    _  _      _  _
|_|_||_||_||\/||_|| \
_|| || || \|  || ||_/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to