Hi gang:

A few times I've found myself confronted with a problem that might be better solved than the way I currently solve it. I would like your opinions/solutions as to how you might solve this.


Here's the given (as an article/author example).

I want to create a list of articles in a database.

The articles are listed in a table with the fields "title", "description", and "author".

article table:
id - title - description - author

The authors are listed in a table with the fields "name" and bio".

author table:
id - name - bio

Now here's the problem each articles will have one, but perhaps more authors -- so how do I record the authors in the article table?

As it is now, I use the remote key for each author and separate each key by a comma in the author field of the article table. For example:

author table:
id - name - bio
1 - tedd - tedd's bio
2 - Rob - Rob's bio
3 - Daniel - Daniel's bio

article table:
id - title - description - author
1 - PHP Beginner - Beginner Topics - 1
2 - PHP Intermediate - Intermediate Topics - 1,2
3 - PHP Advanced - Advanced Topics - 1,2,3

As such, article with id=3 has a title of " PHP Advanced" and a description of "Advanced Topics" with tedd, Rob, and Daniel as authors.

Is there a better way to link multiple authors to an article rather than placing the remote keys in one field and separating them with commas?

Cheers,

tedd

--
-------
http://sperling.com  http://ancientstones.com  http://earthstones.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to