mysql_num_rows
Posted: Thu Mar 13, 2008 6:33 am
i keep getting this everytime i type a russian word in my translator
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\webareas\cm541\translation.php on line 28
the code being
<?
$trans = $_POST["translate"];
include("connection.php");
$connection = @mysql_connect($db_host, $db_user, $db_password) or die("Error Connecting");
mysql_select_db($db_name, $connection);
$query = "select* FROM Dictionary where russian ='$trans'";
$result= mysql_query($query, $connection);
$num_rows = mysql_num_rows($result);
for ($i =0; $i< mysql_num_rows($result); $i++)
{
$english = mysql_result($result, $i, "english");
$russian = mysql_result($result, $i, "russian");
echo '<tr>
<td width="550" height="30"align="center" valign="middle"><a href="'.$english.'?page=">'.$english.'/'.$russian.'</a></td>
</tr>';
}
?>
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\webareas\cm541\translation.php on line 28
the code being
<?
$trans = $_POST["translate"];
include("connection.php");
$connection = @mysql_connect($db_host, $db_user, $db_password) or die("Error Connecting");
mysql_select_db($db_name, $connection);
$query = "select* FROM Dictionary where russian ='$trans'";
$result= mysql_query($query, $connection);
$num_rows = mysql_num_rows($result);
for ($i =0; $i< mysql_num_rows($result); $i++)
{
$english = mysql_result($result, $i, "english");
$russian = mysql_result($result, $i, "russian");
echo '<tr>
<td width="550" height="30"align="center" valign="middle"><a href="'.$english.'?page=">'.$english.'/'.$russian.'</a></td>
</tr>';
}
?>