PDA

View Full Version : problem positioning..



absolut
05-11-2008, 04:50 AM
database structure
http://img236.imageshack.us/img236/4026/ctableiy5.th.jpg (http://img236.imageshack.us/my.php?image=ctableiy5.jpg)

it should display this

http://img247.imageshack.us/img247/1179/38751214ys8.th.jpg (http://img247.imageshack.us/my.php?image=38751214ys8.jpg)



<?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 the cost..
please help me...

abduraooft
05-11-2008, 01:30 PM
How about changing your echo like

echo "<td><input type='checkbox' name='sa[]' value='$row[cid]'></td>";

absolut
05-12-2008, 01:17 AM
How about changing your echo like

echo "<td><input type='checkbox' name='sa[]' value='$row[cid]'></td>";
the output:
cost cost checkbox checkbox
cost cost checkbox checkbox
cost cost checkbox checkbox

I want to appear the checkbox beside with each cost
cost checkbox cost checkbox
cost checkbox cost checkbox
cost checkbox cost checkbox