submitted by
include('includes/dbconnect.php');
$sql = "SELECT * FROM answers WHERE question_id='$question_id' AND status='approved' ORDER BY timestamp ASC";
$result = mysqli_query($db, $sql);
$count = mysqli_num_rows($result);
if ($count < 1){echo 'No answers yet. Submit your answer here.
';} else { for ($i = 1; $i <= $count; $i +=1){ $row = mysqli_fetch_assoc($result); $id = $row['id']; $name = $row['name']; $answer = nl2br($row['answer']); echo '';
echo '
';
}
echo ''.$name.'
'; echo ''.$answer.'
'; echo 'Add your Answer.
'; } ?>