[SOLVED] login error

[harkly]

I have a login that isn't working. It works for another site and I set them up identically.

 

<?php

session_start();

$userid = $_POST['userid'];

$password = $_POST['password'];

$con = mysql_connect("localhost", "root", "") or die("Sorry, unable to validate you now");

mysql_select_db("artdb", $con);


$query = "SELECT * from admins where userid = '$userid' and password = '$password'";

$result = mysql_query($query);

if (mysql_num_rows($result) == 0)

{
   echo "<h2>Sorry, your account was not validated.</h2><br>\n";
   echo "<a href=\"admin.php\">Try again</a><br>\n";
} else
{
   $_SESSION['store_admin'] = $userid;
   header("Location: admin.php");
}
?>

 

Error I am getting --

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\artdb\admin\validate.php on line 18

 

this is line 18

if (mysql_num_rows($result) == 0)

 

Sorry, your account was not validated.

 

My table --

userid  test

name  test          

password  test

 

 

Also,

 

If I open the other site and login then I can log into the new site.

[Adam]

try this:

 

$result = mysql_query($query) or die(mysql_error());

 

A

[harkly]

Thanks!

 

That helped nero down the error msg and I was able to fix it!!