I'm having this error coming out on this script about view data script.
Please help! does i lack of " which is the last third line of the code below.
function ListUnit()
{
?>
<table class="hilite" id="highlight"><thead>
<tr><th>No.</th><th>Owner</th><th>Unit</th><th>Block</th><th>Floor</th><th>Number</th><th>Balance</th><th>Additional Info</th><th>Action</th></tr>
</thead>
<tbody>
<?php
$SQL="SELECT * FROM unit ORDER BY block, floor, unit ASC";
$result=mysql_query($SQL);
$i=1;
while ($row=mysql_fetch_assoc($result))
{
$id=$row['id'];
$ownerName=$row['ownerName'];
$ownerHP=$row['ownerHP'];
$name=$row['unitname'];
$block=$row['block'];
$floor=$row['floor'];
$unitnum=$row['unit'];
$sqft=$row['sqft'];
$resitsyabas=$row['resit_syabas'];
$ltsb=$row['LTSB'];
$ppaa=$row['PPAA'];
$b482=$row['b482'];
$tbs=$row['TBS'];
$addinfo=$row['addinfo'];
$addinfo = wordwrap($addinfo, 30, "<br>", true);
echo "<tr align=\"center\" valign=\"top\">";
echo "<td>$i</td><td align=\"left\" valign=\"top\">Name:$ownerName<br>Contact:$ownerHP</td><td>$name</td><td>$block</td><td>$floor</td><td>$unitnum</td>
<td align=\"left\">LTSB:RM$ltsb<br>PPAA:RM$ppaa<br>482:RM$b482<br>TBS:$tbs</td>
<td align=\"left\">Area:$sqft sqft<br>Meter Syabas:$resitsyabas<br>$addinfo</td><td><a href=\"admin_unit.php?a=1&i=$id\">Edit</a></td>";
echo "</tr>";
$i++;
}
</tbody></table>
}
?>
so, kindly consult. how and where should i fix it?
You can not use HTML tag in a function.
You must be use
function ListUnit()
{
$html = '<table class="hilite" id="highlight"><thead>';
$html .= '<tr><th>No.</th><th>Owner</th><th>Unit</th><th>Block</th><th>Floor</th><th>Number</th><th>Balance</th><th>Additional Info</th><th>Action</th></tr>';
$html .= '</thead>';
$html .= '<tbody>';
$SQL="SELECT * FROM unit ORDER BY block, floor, unit ASC";
$result=mysql_query($SQL);
$i=1;
while ($row=mysql_fetch_assoc($result))
{
$id=$row['id'];
$ownerName=$row['ownerName'];
$ownerHP=$row['ownerHP'];
$name=$row['unitname'];
$block=$row['block'];
$floor=$row['floor'];
$unitnum=$row['unit'];
$sqft=$row['sqft'];
$resitsyabas=$row['resit_syabas'];
$ltsb=$row['LTSB'];
$ppaa=$row['PPAA'];
$b482=$row['b482'];
$tbs=$row['TBS'];
$addinfo=$row['addinfo'];
$addinfo = wordwrap($addinfo, 30, "<br>", true);
$html .= "<tr align=\"center\" valign=\"top\">";
$html .= "<td>$i</td><td align=\"left\" valign=\"top\">Name:$ownerName<br>Contact:$ownerHP</td><td>$name</td><td>$block</td><td>$floor</td><td>$unitnum</td><td align=\"left\">LTSB:RM$ltsb<br>PPAA:RM$ppaa<br>482:RM$b482<br>TBS:$tbs</td><td align=\"left\">Area:$sqft sqft<br>Meter Syabas:$resitsyabas<br>$addinfo</td><td><a href=\"admin_unit.php?a=1&i=$id\">Edit</a></td>";
$html .= "</tr>";
$i++;
}
$html .= "</tbody></table>";
echo $html;
}
?>