mysql_num_rows

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Waxxy
Forum Newbie
Posts: 4
Joined: Wed Mar 12, 2008 11:26 am

mysql_num_rows

Post by Waxxy »

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>';

}

?>
User avatar
N1gel
Forum Commoner
Posts: 95
Joined: Sun Apr 30, 2006 12:01 pm

Re: mysql_num_rows

Post by N1gel »

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();
}
 
miro_igov
Forum Contributor
Posts: 485
Joined: Fri Mar 31, 2006 5:06 am
Location: Bulgaria

Re: mysql_num_rows

Post by miro_igov »

Try adding space between the word select and the * in $query = "select* FROM Dictionary where russian ='$trans'";
Waxxy
Forum Newbie
Posts: 4
Joined: Wed Mar 12, 2008 11:26 am

Re: mysql_num_rows

Post by Waxxy »

Thank you guys, that has worked.
Post Reply