how to get rows??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
rupam_jaiswal
Forum Newbie
Posts: 22
Joined: Thu Jun 05, 2008 12:54 am

how to get rows??

Post by rupam_jaiswal »

HI,
In mysql, I have 2 tables friends, my_page.

friends
--------
id int(11)
username char(40)
person char(40)
type enum('Friend','Blocked')

id username person type
------------------------------------------------------
13 king_nothing Musechild Friend
587 MrRogue ammo Friend
17 Honey MrRogue Friend


my_page
--------
id int(11)
username varchar(30)
page_owner varchar(30)
date_posted datetime
text text

id username page_owner text date
------------------------------------------------------------
4 Honey MrRogue PHP 2010-06-11 12:30:18
5 ammo MrRogue java 2010-06-08 10:54:52
6 mobster ammo both 2010-06-12 21:20:14
7 ammo Wizkid wrong 2010-06-12 21:39:29
8 Honey ammo show 2010-06-12 22:28:52

friends table tells freinds of each member,
say MrRogue is friend of ammo, Honey.Note that MrRogue can come in either username/person field, not necessarily to be in username field.

Now I want rows from my_page where my_page.username, my_page.page_owner both are friends of MrRogue, like

8 Honey ammo show 2010-06-12 22:28:52

Thanks in advance!!!!
Regards
Post Reply