Passer une donnée sql dans autre requete

     $sql = "SELECT id,username,location FROM users WHERE username = '$m'";

     $users = $DB->query($sql);

	 

    

     $amis = $DB->query("SELECT id FROM amis WHERE user_to = '$users->id'    AND  user_from = '$user_id' ");

$sql = $DB->query($sql);

$user = $sql->fetch_object();

echo $user->id;

SELECT id,username,location FROM users INNER JOIN amis ON amis.user_to=users.id WHERE users.username = '$m' AND amis.user_from = '$user_id';

Discussions similaires