[php-list] How to replace ID with data from another table.

Thu, 25 May 2006 18:02:55 -0700

Hi,

I'm working on a project where I have a MySQL table that contains 
profile data. This data has 2 grouping fields one for group and one 
for criteria. The client wants the flexibility to edit and rename 
these grouping fields without having to go back and make changes to 
each profile. With this said, I created 2 more tables one for group 
and one for criteria. Tables would look like this:

PROFILE TABLE
id      profile            group_id      criteria_id
1      data            2            3
2      more data      1            2
3      data            3            1

GROUP TABLE
id      group
1      contractor
2      painter
3      mechanic

CRITERIA TABLE
id      criteria
1      big
2      small
3      huge

When rendering the data in the profile table I need to be able to 
sort by string description of what is in the group and criteria 
tables. Anyone have some input?

The first thing that came to mind was arrays, but I cannot seem to 
get my head around this. Then I thought maybe I could use a temp 
MySQL table or maybe render an other table with the actual group 
names for display. When admin makes changes re-render the display 
table? Can this be done with an SQL statement?

Any input would be helpful.

Sincerely,
Mike
--
Mike Brandonisio          *    Web Hosting
Tech One Illustration     *    Internet Marketing
tel (630) 759-9283        *    e-Commerce
[EMAIL PROTECTED]    *    http://www.jikometrix.net

     JIKOmetrix - Reliable web hosting




Community email addresses:
  Post message: [email protected]
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list



SPONSORED LINKS
Php mysql Job postings

YAHOO! GROUPS LINKS



Reply via email to