Friends of friends tables design in MySQL

Closed

Need MySQL tables design and Php functions to:

1. Show friends of friends

2. Show mutual friends with some user

3. Show friends of friends,I'm not already connected with.

4. Show friends of friends who are online.

5. Show friends path.

MySQL queries should use "order by" so that newest members are on the top of the list.

All MySQL queries must be optimized/indexed so that they work without problems on a busy website with hundreds of thausands of users and can work on MySQL clusters.

This is a running website and I already have MySQL user tables: users_table and online_users. So, I need redesign friends tables.

Skills: MySQL, PHP

See more: design and friends, friends of, top friends friends, mysql running, online design php mysql, mysql user, top list design, online order php mysql, mysql order user online, work order mysql, php top friends, website tables design, mysql users online, show friends, online order mysql, php mysql friends, friends php mysql, mysql friends, mysql online order, top friends, php show queries, php mysql list order, friends members, mysql friends list, friends list mysql

About the Employer:
( 0 reviews ) Spain

Project ID: #2643971

15 freelancers are bidding on average €118 for this job

buraqtech

Check your PMB for details!!!

€85 EUR in 2 days
(70 Reviews)
7.7
leomedina01

Hi sir, please let me know more details and check your inbox(PMB) for further details about my expertises.

€70 EUR in 4 days
(68 Reviews)
6.1
wsfreelanzer

Hi, i am PHP Developer. I reviewed your requirement. I can do this project. Please check more details on private message. Thanks, Raj

€100 EUR in 2 days
(55 Reviews)
6.1
santossystems

Hi, I am interested in your MySQL and PHP project. Please check inbox for more details.

€100 EUR in 1 day
(40 Reviews)
5.5
bistanil98

I have check this requirement,i need to discuss this,please tell me how we can start the discussion.check PM.

€100 EUR in 2 days
(14 Reviews)
5.5
binarygeotech

We can do it perfectly.

€200 EUR in 3 days
(27 Reviews)
5.0
xplorr007

Let's do it :)

€100 EUR in 2 days
(23 Reviews)
4.8
luantnd

Hi, I'm ready do it

€230 EUR in 4 days
(33 Reviews)
4.5
rrafiurr

Sir i am ready to start your work. Please check your pm.

€100 EUR in 2 days
(14 Reviews)
4.0
realimaginations

hi, I am expert of php+mysql. also good in html+css+jquery. see pmb for my work samples. thanks! RI

€75 EUR in 3 days
(15 Reviews)
3.7
Martiny

Greetings. I have experience in MySQL and PHP. Let's start on your project! Have a nice day!

€80 EUR in 2 days
(3 Reviews)
3.0
elyor

I've much experience in designing database models of many systems, including social networks. I can help you.

€50 EUR in 0 days
(0 Reviews)
0.0
crisdoru

I can get this job in no time, Im an expert in PHP and MySQL.

€200 EUR in 3 days
(0 Reviews)
0.0
Abdulhadijatoi

Ready to start, wants to discuss some........

€245 EUR in 7 days
(1 Review)
0.0
rahuljn1232

I am a web/Database Developer I am interested to work with you

€40 EUR in 3 days
(0 Reviews)
0.0