Hi, I have been working on a social networking website http://www.friendsinteract.com am have challenges and I very much welcome any help. Thank you.

The challenge am having is that when a user logs in, his or her own post is fetched first before other of his or her friends post is fetched. Inside the database, there is a column that contain the a user's friends username separated by comma (,) for instance - macwilcy,cy,cyril,cy1,macwilcy1,... I want to use the username to fetch post made by users ordering it by date. I initially used "SELECT * FROM table_name WHERE username = '$username' ORDER BY DATE" but it was fetching the posts starting from the first username to the last username regardless of which user's post is the latest post. I will very much appreciate your help. Thanks

I replied this on ya old thread...meanwhile, you're doing something really wrong.

there is a column that contain the a user's friends username separated by comma (,) for instance - macwilcy,cy,cyril,cy1,macwilcy1,...

This is very very very wrong. Research on how to design a relationship/friendship database.
I have something for you but i want you to research it yourself first. This will help you in your future quests.

spikes C: I replied this on ya old thread...meanwhile, you're doing something really wrong.
This is very very very wrong. Research on how to design a relationship/friendship database.
I have something for you but i want you to research it yourself first. This will help you in your future quests.

Thanks
In my research I saw this:

Table User
--------------
UserID EmailAddress Password Gender DOB Location
------------------------------------------------------
1 bob@bob.com bobbie M 1/1/2009 New York City
2 jon@jon.com jonathan M 2/2/2008 Los Angeles
3 joe@joe.com joseph M 1/2/2007 Pittsburgh

Table Friends
---------------
UserID FriendID
----------------
1 2
1 3
2 3

Is it ok? I would appreciate to know your idea. Your idea is really important to me. Thanks for your help

Gbam, it is so correct!
I'll send you some SQL queries for a few things you might wanna do with that table.

Remember, you can deduce a lotta things with that table structure. example, the first column is the person that sent the friend request.
Remember to add you status column. e.g pending,accepted,banned etc.

spikes C: Gbam, it is so correct!
I'll send you some SQL queries for a few things you might wanna do with that table.

Remember, you can deduce a lotta things with that table structure. example, the first column is the person that sent the friend request.
Remember to add you status column. e.g pending,accepted,banned etc.

Thanks very much