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

[tim108]

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

 

PHP, mySQL error message is showed after I type the username and password into my login fields

 

 

this is the section of code that it is referring to

 

$count=mysql_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row

 

if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php"

session_register("username");

session_register("password");

header("location:login_success.php");

}

else {

echo "wrong username or password";

}

 

any help would be greatly appreciated

Thanks

[sader]

$result must be product of mysql_query("query string") function;

[tim108]

$sql="SELECT * FROM $adminmembers WHERE username='$username' and password='$password'";

$result=mysql_query($sql);

 

thats the code I have above what I posted earlier, is that what you were refering to?

[SpankMarvin]

Do you have a reference to a database connection in that script?

[tim108]

I do yes, this is the entire script from this page

 

<?php

include '../database_conn.php';

// username and password sent from form

$username=$_POST['username'];

$password=$_POST['password'];

 

// To protect MySQL injection (more detail about MySQL injection)

$username = stripslashes($username);

$password = stripslashes($password);

$username = mysql_real_escape_string($username);

$password = mysql_real_escape_string($password);

 

$sql="SELECT * FROM $adminmembers WHERE username='$username' and password='$password'";

$result=mysql_query($sql);

 

// Mysql_num_row is counting table row

$count=mysql_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row

 

if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php"

session_register("username");

session_register("password");

header("location:login_success.php");

}

else {

echo "wrong username or password";

}

 

?>

[SpankMarvin]

Is the dollar sign before your adminmembers table a typo?

[tim108]

that was a typo yes, thankyou!

however after fixing that I know get a series of other error messages,

 

Warning: session_register() [function.session-register]: Cannot send session cookie - headers already sent by

 

Warning: session_register() [function.session-register]: Cannot send session cache limiter - headers already sent

 

Warning: Cannot modify header information - headers already sent

 

Warning: Unknown: Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off, respectively. in Unknown on line 0

[jl5501]

you will get that headers already sent error if anything at all has been output before the call to header().  The most common cause of this is a space before the opening <?php

 

 

[tim108]

that is the code that is bringing up this error message, there are no spacing issues and nothing being outputted?

 

<?php

include '../database_conn.php';

session_start();

if(!session_is_registered(username)){

header("location:admin.php");

}

?>

 

[jl5501]

there is either a space before the <?php in this file or the database_conn.php

 

or a space after the ?> in database_conn.php

 

or an echo somewhere in database_conn.php that is being run

[jl5501]

actually you need to read the whole text of the headers already sent message

 

it will say output started at.....  and that is the info you need

 

[tim108]

thankyou! you have all helped me fix the issue now

cheers guys