$db = mysql_connect("localhost", "user", "password" );
mysql_select_db("vpanel", $db);

$query = 'select * from clientdb'
."where name ='$userid'"
." and pass='$password'";

$result = mysql_query($query);

$num_rows = mysql_num_rows($result);
echo $num_rows;

if(num_rows> 0){
$HTTP_SESSION_VARS['valid_user'] = $userid;


}



What is wrong with this fragment? I got some warning like :

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

I am using php4

try this....

$query = "select * from clientdb where name = '".$userid."' AND pass = '".$password."'";

In your query string, there is no space between 'clientdb' and 'where'


Try:


$query = 'select * from clientdb '
." where name ='$userid' "
." and pass='$password' ";


Hope that helps.

Check your return codes and use mysql_error to get a report of just what the server didn't like. If a query fails and you don't know why, echo $query so you can see exactly what the script is trying to execute. Battling around in the dark like this just makes the work harder.

$db = mysql_connect("localhost", "user", "password" );
mysql_select_db("vpanel", $db);

$query = "select * from clientdb where name ='$userid' and
pass='$password'";

$result = mysql_query($query);

$num_rows = @mysql_num_rows($result);
echo $num_rows;

if(num_rows> 0){
$HTTP_SESSION_VARS['valid_user'] = $userid;


}