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

[doS!]

Hi,
yesterday i downloaded a script.
Now, im installing it on my website, but when i load index.php page and all the page where config.php is included, it say that:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.newsict.com/htdocs/config.php on line 13

this is config.php :

<?php
// Provide Values for Database
$dbhost="host";
$dbname="name";
$dbuser="user";
$dbpass="password";

//Don't change the below 2 lines
  $dbconnect=mysql_connect($dbhost,$dbuser,$dbpass);
  mysql_select_db($dbname);

$rs=mysql_query("select * from adminsettings");
if(mysql_num_rows($rs)>0) {
$arr=mysql_fetch_array($rs);
$sitename=$arr[0];
$siteurl=$arr[1];
$webmasteremail=$arr[2];
$adminpass=$arr[3];

$alertpay=$arr[4];

$fee=$arr[7];

$levels=$arr[8];

$level1=$arr[9];
$level2=$arr[10];
$level3=$arr[11];
$level4=$arr[12];
$level5=$arr[13];
$level6=$arr[14];
$level7=$arr[15];
$level8=$arr[16];
$level9=$arr[17];
$level10=$arr[18];

$forcedmatrix=$arr[19];
$membershipperiod=$arr[20];
$signupbonus=$arr[21];
}
?>

Thanks for you help,guys.

doS!

[krishx343]

Hi

There is an error in your line 12

$rs=mysql_query("select * from adminsettings");

need to supply connection also to execute the query.
Like this:

$rs=mysql_query("select * from adminsettings", $dbconnect);

[doS!]

Hi,
i tried your solution, but it still say the same thing.
Do you have any other idea?

[krishx343]

Hi

Try Like This

<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

if($num_rows>0)
{
 
}

?>

[doS!]

Tried that, but the error is the same, just in a different line :O

[krishx343]

place echo for $rs and see what you getting

[doS!]

place echo where?:)

[vaultdweller123]

one thing is for sure, theres an error in connecting to the database or selecting a table or wrong table names you have renamed it, review your database

[rajarajan2017]

Use like below to identify if you have any errors in your Query. or execute your query in your phpadmin sql editor.

$query = "select * from table";
$result = mysql_query($query) or die(mysql_error());

[it200219]

Try this,

<?php
// Provide Values for Database
$dbhost="host";
$dbname="name";
$dbuser="user";
$dbpass="password";

//Don't change the below 2 lines
  $dbconnect=mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error());
  mysql_select_db($dbname) or die(mysql_error());

$rs=mysql_query("select * from adminsettings")  or die(mysql_error());
if(mysql_num_rows($rs)>0) {
$arr=mysql_fetch_array($rs);
$sitename=$arr[0];
$siteurl=$arr[1];
$webmasteremail=$arr[2];
$adminpass=$arr[3];

$alertpay=$arr[4];

$fee=$arr[7];

$levels=$arr[8];

$level1=$arr[9];
$level2=$arr[10];
$level3=$arr[11];
$level4=$arr[12];
$level5=$arr[13];
$level6=$arr[14];
$level7=$arr[15];
$level8=$arr[16];
$level9=$arr[17];
$level10=$arr[18];

$forcedmatrix=$arr[19];
$membershipperiod=$arr[20];
$signupbonus=$arr[21];
}
?>