Thanks for the help on that. I think that will work eventually.
I am having trouble though.. I guess its more complicated than i originally let on.
The way I\'m trying to do it now, is the form is searching the profile table for sex and returning all uid\'s that match that sex:
$sql = mysql_query("SELECT uid FROM profile WHERE sex=$sex")
//Putting result to array
while($uidarray = mysql_fetch_array($sql)
{
$uid = $uidarray[uid];
//then attempting to retrieve all infomation from 3 tables as you have showed me
$sql2 = ("SELECT a.*, b.*, c.* FROM user AS a, profile AS b, interest AS c WHERE a.uid = b.uid = c.uid and a.uid=$uid");
//putting all returns into array (i\'m not sure if this is right)
$result = mysql_fetch_array($sql2);
$username = $result[username];
echo "$username";
}
I\'m not sure of the best way to do what I\'m trying to do above, but $username isnt returning any value in this instance.
Can ya tell me if the above should work or the best way to do it?
Thanks a ton.