List:General Discussion« Previous MessageNext Message »
From:AndrewJames Date:September 3 2009 8:05am
Subject:need help with relational tables/fields
View as plain text  
Hey,

i have a table called users which has my users in it, each have a uid field.
I also have a stories table which has stories in it each with a sid field
for each story but also a uid field so i know which user the story belongs
to.

i want to write a query that will display the story depending on the user..
basically i guess it works like a word press blog. eg, Andrew logs into the
site and only his stories are displayed, but if john logs in, only his
stories are displayed.

Here are my tables

mysql> describe stories;
+-----------+-----------+------+-----+-------------------+----------------+
| Field     | Type      | Null | Key | Default           | Extra          |
+-----------+-----------+------+-----+-------------------+----------------+
| sid       | int(8)    | NO   | PRI | NULL              | auto_increment |
| uid       | int(8)    | NO   | MUL | NULL              |                |
| story     | text      | NO   |     | NULL              |                |
| storyDATE | timestamp | NO   |     | CURRENT_TIMESTAMP |                |
+-----------+-----------+------+-----+-------------------+----------------+
4 rows in set (0.02 sec)

mysql> describe users;
+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+
| uid       | int(8)      | NO   | PRI | NULL    | auto_increment |
| username  | varchar(12) | NO   |     | NULL    |                |
| password  | varchar(32) | NO   |     | NULL    |                |
| firstName | varchar(15) | NO   |     | NULL    |                |
| lastName  | varchar(15) | NO   |     | NULL    |                |
+-----------+-------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)

 

Thread
need help with relational tables/fieldsAndrewJames3 Sep
  • Re: need help with relational tables/fieldsWolfgang Schaefer3 Sep
  • Re: need help with relational tables/fieldsWolfgang Schaefer3 Sep
  • Re: need help with relational tables/fieldsWolfgang Schaefer3 Sep