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

[Trigs]

@dent: Where should I declare them... lmao
@protege: i know that...

Up to line 66:

<?php
#######################
# Configuration #######
#######################
// Database Connection
removed
// Gets an array with the active user's information
$query = mysql_query("SELECT * FROM users WHERE username = '{$_SESSION['username']}'",$conn);
$userinfo = mysql_fetch_array($query);
// Bans
if($userinfo['banned'] == 'yes') {
 include('banned.php');
 die();
}
// Messages
$msgquery = mysql_query("SELECT * FROM `pms` WHERE `to` = '{$_SESSION['username']}' ORDER BY `id` DESC",$conn); 
$msgnum = mysql_num_rows($msgquery);
// Version No.
$version = 'r1 BETA';
// Admin/System Email
$adminemail = '';
// Errors
$err_login = 'You must be logged in to view this page. Please <a href="login.php">login</a> or <a href="register.php">register</a>.';
$err_auth = 'Only authorized staff can view this page!';
$err_notfound = 'The page you were looking for could not be found. Click <a href="index.php">here</a> to go back to the main page.';
// IP
$ip = $_SERVER['REMOTE_ADDR'];
// Date
$day = date('l'); 
$month = date('F');
$daynum = date('j');
$year = date('Y');
$date = $day.', '.$month.' '.$daynum.', '.$year;
#######################
# System Functions ####
#######################
// Cleaning Input
function clean($str) {
 if(!get_magic_quotes_gpc()) {
     $str = addslashes($str);
    }
 $str = strip_tags(htmlspecialchars($str));
 return $str;
}

I had the exact same thing on a different host and it worked but when I switched it gave me these errors...

[Dentafrice]

I'm not even going to comment on how horrible that code is.

Post the code for the page that presents the error, or give me the link to config.php page.

[Protege]

Shouldnt declare so many variables unless you're going to use them each time you load your config page.

[Trigs]

nvm, fixed it. also a question,

If I do;

require 'config.php';
require 'home.php';

and I had a function in config.php, would I be able to use it in home.php without requiring config.php in home.php?

[Protege]

"and I had a function in config.php, would I be able to use it in home.php without requiring config.php in home.php?"

Can I call my Dad on my home phone which isn't connected to a telephone line?

No you can't, you need to require/include it in the file inorder to use it.

[Dentafrice]

Quit. Putting. *******. Functions. In Your Config File.

---------

Lets say you have this.

config.php - includes database details/connection, etc.
functions.php - includes your clean function and some other things.
home.php - home file.

here's the code on config.php:

<?php
require_once "functions.php";
?>

here's the code on home.php:

<?php
include "config.php";  // includes the config file.

$string = $_GET["string"];
$string = clean($string);

[Blinger1]

Quit. Putting. *******. Functions. In Your Config File.

---------

Lets say you have this.

config.php - includes database details/connection, etc.
functions.php - includes your clean function and some other things.
home.php - home file.

here's the code on config.php:

<?php
require_once "functions.php";
?>

here's the code on home.php:

<?php
include "config.php";  // includes the config file.

$string = $_GET["string"];
$string = clean($string);

or just download a premade user ******* system.

[Dentafrice]

or just download a premade user ******* system.

How does that help anyone learning anything? I'd rather make my own then download a pile of **** that I'm going to spend more time customizing to make it how I want, then actually building it.

[Jxhn]

nvm, fixed it. also a question,

If I do;

require 'config.php';
require 'home.php';

and I had a function in config.php, would I be able to use it in home.php without requiring config.php in home.php?

Yes you can, if you require it in home.php then you will get the error you got before. You can use require_once to stop this happening. Protege you read his post wrong.

[Trigs]

yeah, i already figured that out.