how to make a full PHP and Mysql enabled page

[danishravian]

this is my code
include "connect.php";
$query = "select * from plants";
$result = mysql_query($query);
$row = mysql_fetch_array($result);


$templater->register('query', $query);
$templater->register('result', $result);
$templater->register('row', $row);


if(mysql_num_rows($result) > 0)
{
while($row = mysql_fetch_array($result))
{

echo "data found";

}

}

else
{
echo "No Record With These Parameters";

}