fetching record then result is query was empty

[pushpa4385]

hi,

i have fetching record from mysql database in this formate

<?php
$connsqlhostname = "localhost";
$connbase = "rajgorsamaj";
$connlogin = "pushpa";
$connpassword = "123456";
$db_connect = mysql_connect($connsqlhostname,$connlogin,$connpassword) or die ("<B>Error ".mysql_errno()." :</B> ".mysql_error()."");
 
$query="select id,surname from dataentry";
$rs=mysql_query($qyery) or die(mysql_error());
while($dataentry=mysql_fetch_array($rs))
{  
    $i++;
    echo "<tr>";
    echo "<td align=center><h1><center>".$i."</center></h1></td>";
    echo "<td align=center><h1><center>".$dataentry[0]."</center></h1></td>";
    echo "<td align=center><h1><center>".$dataentry[1]."</center></h1></td>";
}
?> 
 

so why result page is display query was empty

please reply me

[r035198x]

hi,

i have fetching record from mysql database in this formate


<?php
$connsqlhostname = "localhost";
$connbase = "rajgorsamaj";
$connlogin = "pushpa";
$connpassword = "123456";
$db_connect = mysql_connect($connsqlhostname,$connlogin,$connpas sword) or die ("<B>Error ".mysql_errno()." :</B> ".mysql_error()."");

$query="select id,surname from dataentry";
$rs=mysql_query($qyery) or die(mysql_error());
while($dataentry=mysql_fetch_array($rs))
{
$i++;
echo "<tr>";
echo "<td align=center><h1><center>".$i."</center></h1></td>";
echo "<td align=center><h1><center>".$dataentry[0]."</center></h1></td>";
echo "<td align=center><h1><center>".$dataentry[1]."</center></h1></td>";
}


?>





so why result page is display query was empty



please reply me

Are there any values in the table?

[Motoma]

Take a look at these instructions about enabling runtime error messages on pages. Post back once you have an error message to give us.