URGENT - mysql_num_rows error

[phpn00bf4life]

Hey getting an error: http://digishop4u.com/login.php -- the problem is the mysql_num_rows isn't working right.

Username: Test
Pass: test

code:

<?php
session_start();
header("Cache-Control: Private");
ini_set("display_errors", 1);  

error_reporting(E_ALL); 
/*
**Script Creation:  Wednesday, May 18, 2005
**Script Created Via:  PHP, Crimson Editor
**Page Title:  Login
**Page Quick Bio:  Login...
*/
//Display Form
include("config.inc.php");
function display_Form(){
	echo'<form method="POST" action="login.php?op=process">
<p align="center">
  Username:&nbsp; <input type="text" name="username" size="20"><br>
  Password:&nbsp; <input type="password" name="password" size="20"></p>
  <p align="center"><input type="submit" value="Submit" name="submit"><input type="reset" value="Reset" name="reset"></p>
</form>
';
}
//Process it
function process_Form(){
	$query = "SELECT * FROM hard_users WHERE username='".$_POST['username']."' AND password='".$_POST['password']."'";
$num_rows = mysql_num_rows($query);
	if($num_rows != "0"){
		while($check_user = mysql_fetch_array(mysql_query($query))){
			$_SESSION['loggedin'] = $check_user['uid'];
		}
	} else {
		echo'Login error, please click <a href="'.$_SERVER['PHPSELF'].'>here</a>!';
	}
}

switch(isset($op)){
	case "process":
	process_Form();
	break;
	default:
	display_Form();
}
?>

what's wrong?

[thorpe]

numbers dont need to be wrapped in "

so this,

if ($num_rows != "0") {

becomes,

if ($num_rows != 0) {

[phpn00bf4life]

it got me farther, the script loads 😛 but it still got an error (Try login in again)

[kburger]

You're never actually executing that query you created.

$query = "SELECT * FROM hard_users WHERE username='".$_POST['username']."' AND password='".$_POST['password']."'";
$num_rows = mysql_num_rows($query);

should be

$query = "SELECT * FROM hard_users WHERE username='".$_POST['username']."' AND password='".$_POST['password']."'";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);