[Resolved] num_rows

[klik]

I have the following code

$user_id = $_GET['user_id'];

if ((!isset($user_id)) || (!is_numeric($user_id)) || (!$user_id > 0)){
	echo "That user does not exist!";
	exit();
}	


$sql_id_check = mysql_query("SELECT * FROM cms_users WHERE user_id='$user_id'");

$count_check = mysql_num_rows($sql_id_check);

if ($count_check == 0) {
    echo "That user does not exist!";
    exit();

} else{

//Collect variable information from database

Every time I call this script I get 'That user does not exist!' even when they do exist.

I echoed user_id to the screen and it is receiving this value without problems.

Any ideas?

[TheDefender]

You need to concatenate your variable. Change your sql to:

$sql_id_check = mysql_query("SELECT * FROM cms_users WHERE user_id='" . $user_id . "'"); 

[klik]

Thanks for the help, but it still isn't working. Same error.

[TheDefender]

I didn't even notice you are echoing the same error with 2 different tests.
Change this one to something else, so we know which of the 2 are being echoed...(see my additional bold text)

if ((!isset($user_id)) || (!is_numeric($user_id)) || (!$user_id > 0)){
echo "That user does not exist add text here!";
exit();
}
Now that I look back, it looks like this is the one erroring... We need to confirm this before moving on.

[klik]

I resolved it. Seems to be a problem connecting to my db_connect file when I have files in a non root folder.

I just added it to my root and it's working now.

Thanks for your time

[TheDefender]

Glad to hear it. You should consider using [man]die[/man] in your sql statements. This will help with debugging these kinds of errors in the future.