[SOLVED] Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result

[colap]

else if($submitted_by_admin=$_POST['submitted_by_admin']=='yes_admin') {
//        echo "admin:".$submitted_by_admin;
        include("database_connector.php");
        $admin_id = $_POST['admin_id'];
        $admin_password = $_POST['admin_password'];
        $cmd1=mysql_query("select *from admin_info where user_name='$admin_id' AND password='$admin_password'");
        $row1=mysql_fetch_array($cmd1);    ****************/error
        $count1=mysql_num_rows($cmd1);  ****************/error

Error is shown on last two lines.

[mikesta707]

your query is failing. add an

 or die(mysql_error());

 

at the end of your query and see what message you get

[nafetski]

You are not getting any results back off your query.  Try running your SQL straight and see what you get  

 

Also, no reason to re-declare variables.

 

    $cmd1=mysql_query("select *from admin_info where user_name='".$_POST['admin_id']."' etc

[colap]

Solved.