Thread: Website
View Single Post
  #37  
Old 07-31-2008, 01:54 AM
Loriel Loriel is offline
Somewhat rusty
Loriel's Avatar
Join Date: Mar 2001
Posts: 5,059
Loriel is a name known to allLoriel is a name known to allLoriel is a name known to allLoriel is a name known to all
Quote:
Originally Posted by WhiteDragon View Post
Okay. If you are actually experienced with any of the listed skills, you should be able to create this rather generic database model in an efficient and timely matter "using your knowledge":

There are users, posts, and comments. The user to post relation is many to many, the posts to comments relation is one to many.

Provide a simple database model of this. Also provide the SQL statements to show all users, show all posts from a user, and show all comments from a post. Should take about 15 minutes.

Cheers.
char* posters[100];
char* comments[100];
char* posts[100];

for (i = 0; i < 100; ++i) printf("%s\n", posts[i]);

no big deal really
Reply With Quote