[Resolved] Why won't this work?!?!

[HalfLife]

Here is the code:

$num = $_GET['photo'];
$this_pic = mysql_query("SELECT * FROM sketches WHERE id='$num'");
$image_address = mysql_result($this_pic, "image_address");
$image_name = mysql_result($this_pic, "image_name");
$name = mysql_result($this_pic, "name");
$date = mysql_result($this_pic, "date");
$comment = mysql_result($this_pic, "comment");

It returns everything as $num!! If $num=3 then it returns everything as 3!!!

[HalfLife]

Please help me, this is really urgent...
I see that you looked through this post but hadn't replied...
Is it becaus I missed something? Don't you know how to solve this? Post something! Please, don't leave me hanging!!!

[cahva]

$num = $_GET['photo']; 
$result = mysql_query("SELECT * FROM sketches WHERE id='$num'"); 
$row=mysql_fetch_array($result);
$image_address = $row['image_address'];
$image_name = $row['image_name'];
$name = $row['name'];
$date = $row['date'];
$comment = $row['comment'];

[HalfLife]

Thanks!