SQL query not working

[Gniew]

Why is this code not working? All I'm getting is "1" as an echo, when it should be 45GH20 (since, that's what's in the DB)

 

<?
$conn = mysql_connect("localhost","0","0"); $db = mysql_select_db("0");

$x = $_GET['x'];
$y = $_GET['y'];
?>
<table width="75%" border="0">
  <tr>
<td><? $worked2 = mysql_query("SELECT * FROM `map` WHERE `x`=(1) AND `y`=(0)");
	$result2 = mysql_fetch_object($worked2); echo($result2-Number);?></td>
  </tr>
</table>

[AyKay47]

change you query to

 

mysql_query("SELECT * FROM `map` WHERE `x`=1 AND `y`=0") //remove parenthesis

[mikosiko]

$result2 = mysql_fetch_object($worked2); echo($result2-Number)

 

typo? ... that should be $result2->Number ... assuming "Number" is a valid field in your table `map`

[xyph]

If you were reporting all errors, like you should be, it would've thrown a ton of errors pointing to the issue.