At 02:32 PM 10/30/2001 -0700, Steve Meyers wrote:
> > What would be ideal would be to use auto-incremented numeric fields as
> > primary key fields, and then have a special field in each table
> designated
> > as the "user-friendly field". That way, when you want to view the
> contents
> > of a table, the "table viewing" algorithm can take each field marked as
> a
> > foreign key, go to that table, look up the "user-friendly" string for
> that
> > row, and display that instead. This would satisfy the requirements in
> both
> > paragraphs above.
> >
> > Is there already a way to do this, and if not, which of the two options
>
> > above do people usually use?
> >
> > -Bennett
> >
>Generally people do not put "user-friendly fields" in tables. That's
>what joins are for :)
I guess what I wanted was a list of bookmarkable links that I could click
on, which would show me a list of all the users in a table, all the news
sites, etc.
What I probably need is to put the non-user-friendly fields in the tables,
and then come up with a way to store join queries, so that I can "bookmark"
the results. I could just create a form that submits a query through GET
data, and then bookmark the results of the form submission.
Thanks Steve and Gregert :)
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org
(425) 649 9024
---------------------------------------------------------------------
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
