[PHP/mySQL] mysql_num_rows() doesn't work?

[Trigs]

$msgquery = mysql_query("SELECT * FROM pms WHERE to = '{$_SESSION['username']}' ORDER BY id desc",$conn);
$msgnum = mysql_num_rows($msgquery);

I keep getting:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource blah blah blah

[Protege]

SELECT * FROM `pms` WHERE `to` = '' ORDER BY `id` DESC

include 'mysql_config.php'; // mysql db config file etc.

$MySQLQuery = mysql_query( 'SELECT * FROM `pms` WHERE `to` = "' . $_SESSION[ 'username' ] . '" ORDER BY `id` DESC' );
$MySQLRows = mysql_num_rows( $MySQLQuery );

echo $MySQLRows; 

[Trigs]

So the problem was that I didn't use ` right?

[Protege]

I believe so.

[Trigs]

Aha thanks, it worked. +rep

[Trigs]

I'm also having a problem with this...

Fatal error: Cannot redeclare clean() (previously declared in ---/config.php:60) in -------/config.php on line 66

I have register.php which uses clean() several times. It requires config.php which has this from line 60-66:

function clean($str) {
if(!get_magic_quotes_gpc()) {
$str = addslashes($str);
}
$str = strip_tags(htmlspecialchars($str));
return $str;
}

*** is wrong with it?

[Dentafrice]

you're declaring the function clean() more then once.

[Protege]

I believe that means you have the function "Clean" declared twice

[Trigs]

Pretty obvious lol.

I figured it out. I had a function in register.php that also required config.php. I just globalized the vars I needed from config.php instead.

[Trigs]

Okay nevermind, it still doesn't work...

Now it happens with every function I have stored in config.php. For example:

Fatal error: Cannot redeclare clean() (previously declared in ---/config.php:60) in ---/config.php on line 66

Lines 60-66:

function clean($str) {
 if(!get_magic_quotes_gpc()) {
     $str = addslashes($str);
    }
 $str = strip_tags(htmlspecialchars($str));
 return $str;
} 

I don't see what the problem is.