How to call certain information from Mysql using PHP
Date: November 04, 2009 05:02PM
Okay, I don't know what to call this, or where I should exactly place this so please bare with me.
Here's the best way I can explain my problem.
I am trying to make a friends feature using PHP and obviously MySql. I want to make it so that the friends of each user is in one database table for each user.
For instance:
TABLE NAME 'users':
'id'
'username'
'password'
'friends' '1, 4, 75, 34, 25'
The numbers being the User ID's of the friends. Inserting the informaton into the database is not the problem. The prolem is calling the information using PHP so that each friend is seperate allowing me to use the User ID's to get the information for each fried. That is something I cannot figure out how to do for the life of me.
Can anyone shed some light on my dilemna? I would be very much appreciative.
Sorry, only registered users may post in this forum.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.