database structure
it should display this
PHP Code:
<?php
echo'<form method="post" name="myform" action="file.php">';
$result = mysql_query("SELECT iqid, cost, userid FROM ctable where postid=$post");
while ($row = mysql_fetch_array($result))
{
$arr[$row['iqid']][$row['userid']] = $row['cost'];
$uid[] = $row['userid'];
}
$uid = array_unique($uid);
$qid = array_keys($arr);
echo '<table cellpadding=5><tr><td></td>';
foreach($uid as $userid) echo "<td>$userid</td>";
echo '</tr>';
foreach($qid as $iqid)
{
echo "<tr><td>$iqid</td>";
foreach($uid as $userid)
{
echo '<td>';
if (isset($arr[$iqid][$userid])) echo $arr[$iqid][$userid];
echo '</td>';
}
}
$result = mysql_query("SELECT cid FROM ctable WHERE postid=$post");
while ($row = mysql_fetch_array($result))
{
echo "<input type='checkbox' name='sa[]' value='$row[cid]'>";
}
echo "</tr>";
echo '</table>';
echo '<input type="submit" name="listing" />';
echo'</form>';
?>
I've added checkbox and I need to get the cid..
I have problem in positioning, the checkbox appeared in the top of the userid(above userid)
I want the checkbox to appear beside with each cost..
please help me... |
