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

Mysql_fetch_array (): supplied argument is not a valid MySQL result resource
Warning:mysql_fetch_array (): supplied argument is not a valid MySQL result resource in D:\myapacheweb\test\self_info.php On line 7

PHP Code

  
   mysql_connect ("localhost", "root", "1");     $query = "SELECT id from computer where user = ' test2 '";    $result =mysql_query ($query);        echo "Test2 used the
";    while ($row = Mysql_fetch_array ($result))    {        echo $row [' ID ']. " Start time ". $row [StartTime]."
";    }

For help.

------Solution--------------------
$query = "SELECT id from computer where user = ' test2 '";

Echo, $query.

Put the resulting SQL statements in the database and execute them to see if there is any data.

This problem is generally
There is an error in the SQL statement
Or there's no such data in the database.

、
------Solution--------------------
The SQL statement is wrong!
------Solution--------------------
I usually put
$result =mysql_query ($query);
Written:
$result =mysql_query ($query, $conn);


------Solution--------------------
You didn't specify a database, did you? - -
$result =mysql_query ($query);
This is changed into
$result =mysql_db_query (' database name ', $query);

------Solution--------------------
discuss

I usually put
$result =mysql_query ($query);
Written:
$result =mysql_query ($query, $conn);

