1x msql_query() 2x mysql_fetch array()

[gertjuhhh1993]

dag mensen.

ik ben met een projectje bezig waarmee ik met 1 mysql_query 2x een array wil maken.
het gaat om de query op regel 33. deze word in een array gezet op regel 45($chapters) en op regel 89($row2). zoals je ziet staat er in de while functie ook een $page die word ge-echo-ed via de template. de "test234" word niet weergegeven als de pagina klaar is met laden.

<?php
session_start();
if(!isset($_SESSION['logged_in']) || $_SESSION['logged_in'] != true)
{
	header('Location:/?login=false');
}
else 
{
include_once("../../core/includes.php");
//Set Template
if (isset($_GET['id'])) 
{
	$id = $_GET['id'];
        connect();
$query_workbooks = mysql_query("  SELECT

                            *

                        FROM

                            workbooks

                        INNER JOIN

                            workbooks_content

                        ON

                            workbooks.workbooks_id = workbooks_content.workbooks_content_workbooks_id

                        WHERE workbooks.workbooks_id =" . $id . "
                             AND workbooks.workbooks_deleted = '0'");
$query_chapters = mysql_query(" SELECT
                                    *
                                FROM
                                    chapters
                                INNER JOIN
                                    chapters_content
                                ON
                                    chapters.chapters_id = chapters_content.chapters_content_chapters_id
                                WHERE
                                    chapters.chapters_workbooks_id =" .$id . " 
                                AND
                                    chapters.chapters_deleted = '0'") or die(mysql_error());
$chapters = mysql_fetch_array($query_chapters);
if (isset($chapters['chapters_id']))
{
$query_assignments = mysql_query("   SELECT
                                    *
                                FROM
                                    assignments
                                INNER JOIN
                                    assignments_content
                                ON
                                    assignments.assignments_id = assignments_content.assignments_content_assignments_id
                                WHERE
                                    assignments.assignments_chapters_id = " .$chapters['chapters_id']. "
                                AND
                                    assignments.assignments_deleted = '0'") or die(mysql_error());


$assignments = mysql_fetch_array($query_assignments);
}
if (isset($assignments['assignments_id']))
{
$query_questions = mysql_query("   SELECT
                                    *
                                FROM
                                    questions
                                INNER JOIN
                                    questions_content
                                ON
                                    questions.questions_id = questions_content.questions_content_questions_id
                                WHERE
                                    questions.questions_assignments_id = " .$assignments['assignments_id']. "
                                AND
                                    questions.questions_deleted = '0'")or die(mysql_error());
}
$row = mysql_fetch_array($query_workbooks);
$werkboeknaam = $row['workbooks_content_name'];
connect();
$page ='<div id="page_left_teacher_wb">';
$page .= '

<ul>
    <li><a href="#none" onclick="loadWorkbookDetails(\'' . $werkboeknaam . '\');">' . $werkboeknaam . ' details</a></li>';
$page .= '</ul><br />test';

while ($row2 = mysql_fetch_array($query_chapters))
{
    $page.= $row2['chapters_content_name'];
    $page .= "test234";
    
}

$page .= '<ul id="workbook_edit_list">';

$page .= '<li>Hoofdstuk 1
            <ul>
                <li><a href="javascript:void(0);" onClick="loadEditWorkbook('; $page .= $id . ');">Vraag 1</a>
                    <ul>
                        <li>Subvraag 1</li>
                    </ul>
                </li>
                <li>Vraag 2</li>
            </ul>

          </li>';

$page .= '</ul>';
$page .= '</div>';
    
$page .='<div id="page_right_teacher_wb">';
$page.='<form id="frmAddUser" action="" method="POST">
                        <table>
                                <tr>
                                        <td>
                                                Werkboek naam:
                                        </td>
                                        <td>
                                                <input type="text" name="txtWerkboeknaam" id="txtWerkboeknaam" value="' . $werkboeknaam . '">
                                        </td>
                                    </tr>
                        </table>
             </form>';
$page .= '</div>';
include('../../templates/layout_teachers.php');
//include('assets/js/header.php');
}
}
?>

wie kan mij hiermee helpen?

alvast bedankt

 

[kenikavanbis]

haal eens alle enters uit je query dan werkt het mogelijks wel