[SOLVED] displaying articles from a database

[joshgarrod]

hello, can someone please have a look at this script and see if you can work out why it isnt working? It is meant to display an article but dependant upon what link is clicked on the page before:

 

<?php
$con = mysql_connect("ljytj","yukk","rykylu");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("sfghjdfgj", $con);

$page = $_GET['ID']; // This will be the ID of the page
$page = mysql_real_escape_string(strip_tags($page));

  $query = mysql_query("SELECT * FROM Animals WHERE `ID` = '$page'");

   if(mysql_num_rows($query)==0){

    die("Sorry, but the page doesnt exist!");

      }else{
         
	         $result = mysql_query($query);

$i=0;


while ($i < $result) {
$Article=mysql_result($result,$i,"Article");
$Text=mysql_result($result,$i,"Text");

print "<table><tr><td>$Article</td></tr>";
print "<tr><td>$Text</td></tr></table>";
          }
             
     }

?>

[The Little Guy]

Why are you doing the query twice? or should I say, why are you querying the query?

[joshgarrod]

lol, i dont know, well spotted. thatw as the prob