Trouble acquiring variable from database

[CagedApe]

I have a page called attack.php. Everything works except when I try to get $defender_name. I have a feeling there's something wrong with my second sql query, but I'm still a noob so I can't see it. I would appreciate some help from the resident experts

 

session_start();
include "config.php";

//Get AttackId from url
if (isset($_GET['id']) && $_GET['id']!='') {
$AttackId=$_GET['id'];
}

//Select attack info(defender's id, winner's id)
$q=mysql_query("SELECT * FROM attack WHERE attackid = $AttackId");
$row = mysql_fetch_array($q);

$defender_id = $row['defender_id'];

// Find defender's username
$q1="SELECT login FROM members WHERE member_id = $defender_id";
$row2 = mysql_query($q1);

$defender_name = $row2['login'];

//Show result
if ($_SESSION['SESS_MEMBER_ID'] = $row['winner_id']){
    echo "You have defeated ". "$defender_name";
}
else{
    echo "You have been defeated by ". "$defender_name";
}  

[inversesoft123]

everything is fine here just need to update query as

 

session_start();
include "config.php";

//Get AttackId from url
if (isset($_GET['id']) && $_GET['id']!='') {
$AttackId=$_GET['id'];
}

//Select attack info(defender's id, winner's id)
$q=mysql_query("SELECT * FROM attack WHERE attackid='".$AttackId."'");
$row = mysql_fetch_array($q);

$defender_id = $row['defender_id'];

// Find defender's username
$q1=mysql_query("SELECT login FROM members WHERE member_id='".$defender_id."'");
$row2 = mysql_fetch_array($q1);

$defender_name = $row2['login'];

//Show result
if ($_SESSION['SESS_MEMBER_ID'] = $row['winner_id']){
    echo "You have defeated ". "$defender_name";
}
else{
    echo "You have been defeated by ". "$defender_name";
}