mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]

by

You are not doing error checking after the call to mysql_query:

$result = mysql_query("SELECT * FROM student WHERE IDNO=".$_GET['id']);
if (!$result) { // add this check.
    die('Invalid query: ' . mysql_error());
}

In case mysql_query fails, it returns false, a boolean value. When you pass this to mysql_fetch_array function (which expects a mysql result object) we get this error.

More Related Contents:

  1. HTML Form/PHP connected but MySQL is empty
  2. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  3. Php charset information [duplicate]
  4. Save the data into a database and return another value from database using PHP
  5. Math Symbol From Mysql To HTML? [closed]
  6. Create hyperlink from html table row to open record on a new page
  7. Is the following code valid? [closed]
  8. How to insert images into a database using PHP [closed]
  9. How to retrieve images from MySQL database and display in an html tag
  10. Preserve Line Breaks From TextArea
  11. How to upload images into MySQL database using PHP code
  12. Fetching data from MySQL database to HTML dropdown list
  13. HTML – Change\Update page contents without refreshing\reloading the page
  14. Delete multiple rows by selecting checkboxes using PHP
  15. “slash before every quote” problem [duplicate]
  16. How to add a delete button to a PHP form that will delete a row from a MySQL table
  17. Dynamic table in HTML using MySQL and php
  18. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  19. display data from SQL database into php/ html table [closed]
  20. How to display an BLOB image stored in MySql database?
  21. Sending HTML Code Through JSON
  22. Javascript function post and call php script
  23. PHP – Secure member-only pages with a login system
  24. PHP: Inserting Values from the Form into MySQL
  25. onbeforeprint() and onafterprint() equivalent for non IE browsers
  26. Creating dynamic tables in HTML using MySQL and PHP
  27. Create table with PHP and populate from MySQL
  28. mysql_fetch_array skipping first row
  29. Displaying BLOB image from Mysql database into dynamic div in html
  30. Using PHP to upload file and add the path to MySQL database

Leave a Comment