mysql - Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, null given in C:\wamp\www\widget_corp\data_base.php -


i trying select data mysql table, warnings:

notice: undefined variable: result in c:\wamp\www\widget_corp\data_base.php on line 40

and one:

warning: mysqli_fetch_row() expects parameter 1 mysqli_result, null given in c:\wamp\www\widget_corp\data_base.php on line 40

this code:

   $connection = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);      // test if connection occured      if (mysqli_connect_errno()){         die ("database connection failed: " . mysqli_connect_errno() . " (" .              mysqli_connect_errno() . ")"  );     }      // perform database query     $query = "select * subjects " ;      $resut = mysqli_query($connection, $query);      // test if there query error     if (!$resut){       die ("database connection failed!");     }      // use return data if     while ($row = mysqli_fetch_row($result)){       //output data each row       var_dump($row);       echo "<hr />";     } 

everything works fine until while(). suggestions/solutions? in advance!

be more attentive, have syntax mistake in:

$resut = mysqli_query($connection, $query); 

change to:

$result = mysqli_query($connection, $query); 

and change to:

if (!$result){       die ("database connection failed!"); } 

Comments

Popular posts from this blog

tcpdump - How to check if server received packet (acknowledged) -