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>';
}
?>
mysql_num_rows
Moderator: General Moderators
Re: mysql_num_rows
Sounds like there could be an error in your SQL query. You could test it with
Code: Select all
$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'";
if($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>';
}
}
else
{
echo 'QueryFailed';
echo mysql_error();
}
Re: mysql_num_rows
Try adding space between the word select and the * in $query = "select* FROM Dictionary where russian ='$trans'";
Re: mysql_num_rows
Thank you guys, that has worked.