mysql_numrows()

[Sooth]

Hi!

 

I'm making a PMs script for an website and I get an error regarding mysql_numrows. I dont know if the error is in the database or in the script, so I'm showing them both.

 

Here is the database table <i>pms</i>:

 

Here is the script:

<?php
mysql_connect($db_hostname,$db_username,$db_password);
@mysql_select_db($db_database)or die($db_error); 
$query="SELECT * FROM pms WHERE to='$_SESSION[username]'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>

 

This is the error:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/a3033866/public_html/myprofile_messages.php on line 14

 

Line 14 is the one where mysql_numrows is called.

[victor_ar]

hello, try this:

 

<?php

$connection = mysql_connect($db_hostname,$db_username,$db_password);

@mysql_select_db($db_database, $connection)or die($db_error);

 

$query="SELECT * FROM pms WHERE to = '" . $_SESSION["username"] . "'";

 

$result=mysql_query($query, $connection);

 

$num=mysql_numrows($result);

 

mysql_close($connection);

 

?>

[victor_ar]

sorry, also use mysql_num_rows instead mysl_numrows