This script is meant to download serialized data (array) from the db,
unserialize it and output it. It has stopped working (not outputing
anything).
I have been looking at it for an hour and cannot see why! It was working
earlier on - can you see the mistake?
<?
global $submitted, $count, $module1;
include('admin/connect.php');
$link="images/logo_small.gif";
$up= "";
function display_result($module_no) {
if ($module_no != "") {
$module_no =unserialize ($module_no);
foreach ($module_no as $number => $data) {
$count=$count+1;?>
Q.<?=$count; ?>- <span style="font-weight:bold"><?=$data;?></span><BR />
<?
}
}
}
$query = "SELECT * FROM consultants WHERE username='myuser'";
// Execute the query and put results in $result
$result= mysql_query($query);
while ($row = @mysql_fetch_array($result, MYSQL_ASSOC)){
// Get number of rows in $result.
$module1= $row['module1'];
$module2= $row['module2'];
$module3= $row['module3'];
$module4= $row['module4'];
$module5= $row['module5'];
$module6= $row['module6'];
$module7= $row['module7'];
}
?>
<body>
<div id="main_box">
<div id="content_holder">
<? include ('header.php'); ?>
<div id="left" style="line-height: 180%; text-align:right; color:#FFFF99;
font-weight:bold">Module Evaluation Result:</div>
<div id="right" style="padding-left: 5px; ">
<div style="padding-left: 10px; padding-top: 0px">
<span class="red_text"></span>
<table width="326" border="0" cellpadding="0" cellspacing="20">
<tr valign="top">
<td width="162">Module 1 Results<br />
<br />
<?
display_result($module1);?>
</td>
<td width="148">Module 2 Results<br />
<br />
<? display_result($module2);?></td>
</tr>
<tr valign="top">
<td>Module 3 Results<br /><br />
<? display_result($module3);?></td>
<td>Module 4 Results<br /><br />
<? display_result($module4);?></td>
</tr>
<tr valign="top">
<td>Module 5 Results<br /><br />
<? display_result($module6);?></td>
<td>Module 6 Results<br /><br />
<? display_result($module4);?></td>
</tr>
<tr>
<td>Module 7 Results<br /><br />
<? display_result($module7);?></td>
<td></td>
</tr>
</table>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
