}
$sql = 'select * from tb_schools';
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
echo '<option value=' . $row['id'];
if (array_search($row['id'], $schools) !== false) {
echo ' selected ';
}
echo '>' . $row['name'] . '</option>';
}
?>
</select>
</td>
<td colspan="2">
<input name="convenant" style="width:388px;" class="rounded" type="text" value="<?php
echo post_or_row($list, 'convenant');
?>
">
</td>
</tr>
<tr>
<td colspan="3">
<div id="loading" style="display:none;height:100px;width:100px;position:absolute;top:776px;left:688px;z-index:50;padding-left:25px;"><img style="padding-left:0px;padding-top:10px" src="/images/84.gif" border="0"></div>
<?php
if ($id != '') {
?>
<img src="images/uploadicon.jpg" /><span id="buttonplaceholder"></span><div id="container"><ul id="upload_list" class="ui-sortable" style="padding-top:5px;list-style-type: none;">
<?php
$sql = 'select * from tb_subdivision_images where subdivisionid=' . $id . ' order by ordr asc';
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
<th>Building Age</th>
<th>Full Baths</th>
<th>Half Baths</th>
<th colspan="2">Upload Image</th>
</tr>
<tr>
<td><input name="building_age" type="text" class="rounded" value="<?php
echo post_or_row($list, 'building_age');
?>
" /></td>
<td><input name="full_baths" type="text" class="rounded" value="<?php
echo post_or_row($list, 'full_baths');
?>
" /></td>
<td><input name="half_baths" type="text" class="rounded" value="<?php
echo post_or_row($list, 'half_baths');
?>
" /></td>
<td colspan="2"><img src="images/uploadicon.jpg" /></td>
</tr>
<tr>
<td colspan="3"><input type="submit" name="submitedit" value=" " class="savebtn" /></td>
<td colspan="2"> </td>
</tr>
</table>
</form>
</div>
</body>
echo '>' . $type[$i] . '</option>';
}
?>
</select></td>
</tr>
<tr>
<th>Website url</th>
<th>Phone Number</th>
</tr>
<tr>
<td><input type="text" style="width:232px;" class="rounded" name="url" value="<?php
echo post_or_row($use, 'url');
?>
" /></td>
<td><input type="text" class="rounded" name="phone" value="<?php
echo post_or_row($use, 'phone');
?>
" /></td>
</tr>
<tr>
<th colspan="2">User image</th>
<th>Logo image</th>
</tr>
<tr>
<td colspan="2"><input type="file" name="userimage" /></td>
<td><input type="file" name="logoimage" /></td>
</tr>
<tr>
<td><?php
if ($use['personimage'] != '') {
<tr>
<td valign="top">http://<input name="brokerage_site" type="text" style="width: 230px;" class="rounded" value="" /></td>
<td></td>
<td></td>
</tr>
<tr>
<th>Personal Website</th>
<th>Personal Image</th>
<th> </th>
</tr>
<tr>
<td valign="top">http://<input name="website" type="text" style="width:230px;" class="rounded" value="<?php
echo post_or_row($use, 'website');
?>
" /></td>
<td valign="top"><input name="personal_image" type="file"/></td>
<td><?php
if ($use['personal_image'] != '') {
echo '<img src="/images/' . $use['personal_image'] . '" border=0>';
} else {
echo ' ';
}
?>
</td>
</tr>
<?php
}
?>
<th colspan="2">Residences</th>
<th colspan="2">Links</th>
</tr>
<tr>
<td colspan="2"><textarea name="residences" type="text" class="rounded" value="<?php
echo post_or_row($list, 'residences');
?>
" style="width: 390px;height:180px;margin-right:15px;" /><?php
echo post_or_row($list, 'residences');
?>
</textarea></td>
<td colspan="2"><textarea name="links" class="rounded" style="width: 390px; height:180px;" value="<?php
echo post_or_row($list, 'links');
?>
"><?php
echo post_or_row($list, 'links');
?>
</textarea></td>
</tr>
<tr>
<td colspan="2"><select class="rounded" multiple style="height:auto;" name=schools[]>
<?php
$schools = array();
$sql = 'select schoolid from tb_subdivision_school where subdivisionid=' . $id;
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
$schools[] = $row['schoolid'];
}
$sql = 'select * from tb_schools';
$res = mysql_query($sql);
echo post_or_row($list, 'listing_no');
?>
" />
</td>
</tr>
<tr>
<th>House plan</th>
<th>Builder</th>
</tr>
<tr>
<td><input name="house_plan" type="text" class="rounded" value="<?php
echo post_or_row($list, 'house_plan');
?>
" /></td>
<td><input name="builder" type="text" class="rounded" value="<?php
echo post_or_row($list, 'builder');
?>
" /></td>
</tr>
<tr>
<th colspan="5">
Upload Image
</th>
</tr>
<tr>
<td colspan="5">
<input type=hidden name=neworder id=neworder>
<div id="loading" style="display:none;height:100px;width:100px;position:absolute;top:549px;left:819px;z-index:50;padding-left:25px;"><img style="padding-left:0px;padding-top:10px" src="/images/84.gif" border="0"></div>
<img src="images/uploadicon.jpg" /><span id="buttonplaceholder"></span><div id="container"><ul id="upload_list" class="ui-sortable" style="padding-top:5px;list-style-type: none;">
<?php
$sql = 'select * from tb_listing_images where listingid=' . $id . ' order by ordr asc';
