Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jun 22nd, 2012  |  syntax: None  |  size: 0.54 KB  |  hits: 11  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
  2. $sql = "SELECT * FROM $tbl_name WHERE....
  3.  $result=mysql_query($sql);
  4.  $row = mysql_fetch_assoc($result);
  5.        
  6. print mysql_error();
  7.        
  8. $sql = "SELECT * FROM $tbl_name WHERE....";
  9.  
  10. if ($result = mysql_query($sql)) {
  11.     $row = mysql_fetch_assoc($result);        
  12. }
  13. else print mysql_error();
  14.        
  15. $sql = "SELECT * FROM $tbl_name WHERE....";
  16. $res = mysql_query($sql) or trigger_error(mysql_error()." in ".$sql);
  17. $row = mysql_fetch_assoc($result);
  18.        
  19. or die(mysql_error());