mysql fetch array expects parameter 1 to be resource problem

Question

Possible Duplicate     ldquo Warning  mysql fetch array   expects parameter 1 to be resource  boolean given rdquo  error while trying to create a php shopping cart       I don t get it  I see no mistakes in this code but there is this error  please help  mysql fetch array   expects parameter 1 to be resource problem   lt  php         con   mysql connect  localhost   root   nitoryolai123           if    con                die  Could not connect      mysql error                  mysql select db  school    con           result   mysql query  SELECT   FROM student WHERE IDNO     GET  id           gt                                     lt  php while   row   mysql fetch array  result       gt                                                     lt table class  a   border  0  align  center  cellpadding  0  cellspacing  1  bgcolor   D3D3D3  gt       lt tr gt        lt form name  formcheck  method  get  action  updateact php  onsubmit  return formCheck this    gt       lt td gt       lt table  border  0  cellpadding  3  cellspacing  1  bgcolor    gt       lt tr gt        lt td  colspan  16  height  25   style  background  5C915C  color white  border white 1px solid  text-align  left  gt  lt strong gt  lt font size  2  gt Update Students lt  td gt         lt tr gt       lt td width  30  height  35  gt  lt font size  2  gt  I D Number  lt  td gt       lt td width  30  gt  lt input  name  idnum  onkeypress  return isNumberKey event   type  text  maxlength  5  id  numbers   value   lt  php echo   GET  id      gt   gt  lt  td gt       lt  tr gt        lt tr gt       lt td width  30  height  35  gt  lt font size  2  gt  Year  lt  td gt       lt td width  30  gt  lt input  name  yr  onkeypress  return isNumberKey event   type  text  maxlength  5  id  numbers   value   lt  php echo  row  YEAR      gt   gt  lt  td gt    lt  php     gt    I m just trying to load the data in the forms but I don t know why that error appears  What could possibly be the mistake in here

User · Answer

In your database what is the type of  IDNO   You may need to escape the sql here    result   mysql query  SELECT   FROM student WHERE IDNO     GET  id

User · Answer

id   intval   GET  id      sql    SELECT   FROM student WHERE IDNO  id    result   mysql query  sql  or trigger error mysql error    sql     always do it this way and it will tell you what is wrong

User · Answer

Make sure that your query ran successfully and you got the results  You can check like this    result   mysql query  SELECT   FROM student WHERE IDNO     GET  id    or die mysql error       if  is resource  result           your while loop and fetch array function here

User · Answer

Give this a try   indo   GET  id     result   mysql query  SELECT   FROM student WHERE IDNO   indo       I think this works

User · Answer

You are using this    mysql fetch array  result    To get the error you re getting  it means that  result is not a resource    In your code   result is obtained this way     result   mysql query  SELECT   FROM student WHERE IDNO     GET  id       If the SQL query fails   result will not be a resource  but a boolean -- see mysql query   I suppose there s an error in your SQL query -- so it fails  mysql query returns a boolean  and not a resource  and mysql fetch array cannot work on that    You should check if the SQL query returns a result or not     result   mysql query  SELECT   FROM student WHERE IDNO     GET  id     if   result     false           use  result   else          an error has occured     echo mysql error        die        note   echoing the error message and dying                 is OK while developping  but not in production       With that  you should get a message that indicates the error that occured while executing your query -- this should help figure out what the problem is  -    Also  you should escape the data you re putting in your SQL query  to avoid SQL injections    For example  here  you should make sure that   GET  id   contains nothing else than an integer  using something like this     result   mysql query  SELECT   FROM student WHERE IDNO     intval   GET  id        Or you should check this before trying to execute the query  to display a nicer error message to the user

User · Answer

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

User · Answer

The most likely cause is an error in mysql query    Have you checked to make sure it worked  Output the value of  result and mysql error    You may have misspelled something  selected the wrong database  have a permissions issue  etc  So    id    int   GET  id       this also sanitizes it  sql    SELECT   FROM student WHERE idno    id    result   mysql query  sql   if    result      die  Error running  sql      mysql error         Sanitizing   GET  id   is really important  You can use mysql real escape string   but casting it to an int is sufficient for integers  Basically you want to avoid SQL injection

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

Examples related to php

Examples related to mysql

Examples related to html