با سلام
در تیبل sql از - استفاده نکن
مثل این
friend-Uname
چون ارور میده
بعد
بفرما
<?php
$username="test";
$sqlu = mysql_query("SELECT * FROM usersetting WHERE usersName = '".$username."' ");
$rowu = mysql_fetch_assoc($sqlu);
$collegeNameu = $rowu['collegeName'];
$query = "SELECT * FROM friends WHERE userName NOT LIKE '".$username."' AND friendUname NOT LIKE '".$username."'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
$querys = "SELECT * FROM usersetting WHERE usersName NOT LIKE '".$username."' AND usersName LIKE '".$row['userName']."' AND collegeName LIKE '".$collegeNameu."' ";
$results = mysql_query($querys);
while($rows = mysql_fetch_array($results)){
echo $row['userName'];
echo "<br>";
};
};
?>