mysql_fetch_array gives a warning

Question

I have problems with mysql_fetch_array. I get a warning:

mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\wamp\www\bb.php on line 6 bool(false)

Here is my code:

if (isset($_POST['chapter'])AND isset($_POST['verse'])){
  $db=mysql_connect("localhost","fruanthony","admin");  
  mysql_select_db("gths",$db);  
  $results=mysql_query("SELECT * FROM bible where verse=".$_POST['verse']."AND            chapter=".$_POST['chapter']);  
  while($a=mysql_fetch_array($results)){    
   echo $a['info'] ;
   echo "<br>";  
  }  
}

What does this have to do with Java? It looks like MySQL and PHP... — BenM, Feb 07 '13 at 10:01
Btw almost everything in your code is bad practice, fetching stuff from bible included. — moonwave99, Feb 07 '13 at 10:05

score 0 · Answer 1 · answered Feb 07 '13 at 10:02

0

$results=mysql_query("SELECT * FROM bible where verse='".$_POST['verse']."' AND            chapter='".$_POST['chapter']."'");

You are missing single quotes in query values '".$_POST['chapter']."'" note the sigle quotes

answered Feb 07 '13 at 10:02

Prasanth Bendra

29,105
8
50
70

score 0 · Answer 2 · answered Feb 07 '13 at 10:02

0

replace

$results=mysql_query("SELECT * FROM bible where verse=".$_POST['verse']."AND chapter=".$_POST['chapter']);

TO

$results=mysql_query("SELECT * FROM bible where verse = '".$_POST['verse']."' AND chapter = '".$_POST['chapter']."'");

answered Feb 07 '13 at 10:02

Devang Rathod

6,434
2
22
31

i have done so but the query does not return anything – Anthony 2013 Feb 07 '13 at 11:17
if you done is really good. – Devang Rathod Feb 07 '13 at 11:21

score 0 · Answer 3 · answered Feb 07 '13 at 10:13

Now try :)

if (isset($_POST['chapter']) AND isset($_POST['verse'])) {

// Dont ignore SQL injection
    $safeChapter = mysql_real_escape_string($_POST['chapter']);
    $safeVerse = mysql_real_escape_string($_POST['verse']);


    $db=mysql_connect("localhost","fruanthony","admin");  
    mysql_select_db("gths",$db);  
    $results=mysql_query("SELECT * FROM bible where verse='".$safeVerse."' AND chapter='".$safeChapter."';");  
    while($a=mysql_fetch_array($results))  
    {    
        echo $a['info'] ;
        echo "<br>";  
    }  
}

mysql_fetch_array gives a warning

3 Answers3