Whats wrong with this?

[andylord]

<?
$Name = "Initiate Touch of Fire";
$query = SELECT * FROM Runesred WHERE Name='$Name' or die                      ('Error Selecting');
$result = mysql_query($query, $connection)or die                      ('Error Results');;
$Name2 = mysql_result($result,"Name");
$Image = mysql_result($result,"Image");
$Class = mysql_result($result,"Class");
$Level = mysql_result($result,"Level");
$Damage = mysql_result($result,"Damage");
$Effect = mysql_result($result,"Effect");
$DroppedBy = mysql_result($result,"DroppedBy");
$Description = mysql_result($result,"Description");
$Mana = mysql_result($result,"Mana");


echo "<tr><td>$Name2</td><td></td></tr><tr><td>$Image</td><td> </td></tr><tr><td>$Class</td><td> </td></tr><tr><td>$Level</td><td> </td></tr><tr><td> </td><td>$Damage</td></tr><tr><td> </td><td>$Effect</td></tr><tr><td> </td><td>$DroppedBy</td></tr><tr>  <td> </td><td>$Description</td></tr><tr><td> </td><td>$Mana</td></tr></table>";
?>

 

Looking for a while cant find it maybe another couple eyes could ? Before its just all the connection information (works tested)

[jonsjava]

forgot to put your query in quotes.

[andylord]

forgot to put your query in quotes.

 

Lol i feel like a idiot now, cheers for the help

[jonsjava]

Oh, and I decided to clean the code up a bit.

<?
$Name = "Initiate Touch of Fire";
$query = "SELECT * FROM `Runesred` WHERE `Name`='$Name';" or die('Error Selecting\n<br />'.mysql_error());
$result = mysql_query($query, $connection)or die("Error Results: \n<br />".mysql_error());
while ($res = mysql_fetch_assoc($result)){
$Name2 = $res['Name'];
$Image = $res['Image'];
$Class = $res['Class'];
$Level = $res['Level'];
$Damage = $res['Damage'];
$Effect = $res['Effect'];
$DroppedBy = $res['DropedBy'];
$Description = $res['Description'];
$Mana = $res['Mana'];
echo "<tr><td>$Name2</td><td></td></tr><tr><td>$Image</td><td> </td></tr><tr><td>$Class</td><td> </td></tr><tr><td>$Level</td><td> </td></tr><tr><td> </td><td>$Damage</td></tr><tr><td> </td><td>$Effect</td></tr><tr><td> </td><td>$DroppedBy</td></tr><tr>  <td> </td><td>$Description</td></tr><tr><td> </td><td>$Mana</td></tr></table>";	
}
?>

[andylord]

Ty so much showed me a few things there

[jonsjava]

....and made a goof up as well...

[andylord]

....and made a goof up as well...

 

Lol no worries i got it working ty again