0

I have my codes which gives me the following eror,

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\jopasy_community_2.2\includes\view.php on line 28

Below are the codes 

<?php
    include 'connection.php';
    $con = mysql_connect($host,$user,$pwd);
    $db = mysql_select_db($database);

    include 'create_tables.php';

    $sql = 'SELECT name, qntitle, question  FROM questions';

    $retval = mysql_query( $sql, $con );
    if(! $retval )
    {
      die('Could not get data: ' . mysql_error());
    }
    while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
    {
    $qnabout=$row['qntitle'];

        echo "<b>Question: </b>{$row['question']} <br>".
         "<b>Asked by : </b> {$row['name']} <br> ".
         "<b>Question about: </b> {$row['qntitle']} <br><br> ".

         "<b>Answers</b> <br><br> ".

        $getanswer = ("SELECT answerdby, answer FROM answers WHERE qntitle ='".$qnabout."';");
        $answer = mysql_query( $getanswer, $con );

        while($ans = mysql_fetch_array($answer, MYSQL_ASSOC)) //This is the line witherror
        {
         echo "Answer : {$ans['answer']} <br> ".
         "<b>Answered by : </b> {$ans['answerdby']} <br> ".
         "--------------------------------<br><br><br><hr>";
        }

    } 
    mysql_close($con);

?>
Cœur
  • 34,719
  • 24
  • 185
  • 251
Paul Alan Paul
  • 1
  • 1
  • Do not use the `mysql_*` api, its deprecated and bad. Use `PDO` or `Mysqli` instead. (this is not related to the question, but a general recommendation). – Jite Apr 09 '14 at 12:29
  • possible duplicate of [mysql\_fetch\_array() expects parameter 1 to be resource, boolean given in select](http://stackoverflow.com/questions/2973202/mysql-fetch-array-expects-parameter-1-to-be-resource-boolean-given-in-select) – nKn Apr 09 '14 at 12:39

2 Answers2

0

Have you checked if your query is returning result? If it is...

Replace:

while($row = mysql_fetch_array($retval, MYSQL_ASSOC))

With:

while($row = mysql_fetch_assoc($retval))

Update

Having looked at your question again, several things comes to mind:

  • You are using MySQL_* (deprecated, switch to MySQLi or PDO)
  • Query within query?

So, I have come up with the following. Try this out:

<?php

// Connect
$mysqli = new mysqli("localhost", "my_user", "my_password", "my_database");
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

// Load Questions
$questions = array();
if ($result = $mysqli->query("SELECT name, qntitle, question FROM questions"))
{
    while ($row = $result->fetch_assoc())
        $questions[] = $row;

    $result->free();
}

// Load Answers
$answers = array();
foreach ($questions as $question)
{
    $qnabout = $question['qntitle'];
    if ($stmt = $mysqli->prepare("SELECT answerdby, answer FROM answers WHERE qntitle = ?"))
    {
        $stmt->bind_param("s", $qnabout);
        $stmt->execute();
        $result = $stmt->get_result();

        while ($row = $result->fetch_assoc())
            $answers[$qnabout][] = $row;

        $stmt->close();
    }
}

// Close Connection
$mysqli->close();

// Display Results
foreach ($questions as $question)
{
    echo "<b>Question: </b>{$question['question']} <br>".
         "<b>Asked by : </b> {$question['name']} <br> ".
         "<b>Question about: </b> {$question['qntitle']} <br><br> ".
         "<b>Answers</b> <br><br> ";

    foreach ($answers[$question['qntitle']] as $answer)
    {
        echo "Answer : {$answer['answer']} <br> ".
             "<b>Answered by : </b> {$answer['answerdby']} <br> ".
             "--------------------------------<br><br><br><hr>";
    }
}
Latheesan
  • 21,527
  • 27
  • 96
  • 188
0

$answer contains boolean because of error in query. Check var_dump(mysql_error($con)) for errors. Also, mysql_* functions are deprecated. Use mysqli or PDO instead.

Related question: mysqli_fetch_array()/mysqli_fetch_assoc()/mysqli_fetch_row() expects parameter 1 to be resource or mysqli_result, boolean given

Community
  • 1
  • 1
Timur
  • 6,578
  • 1
  • 25
  • 37