I have been faced with this problem for a few days i have this script that retrieves data from the database and display it to the user but i want to load this database in jquery modal box please assist anyone:
Script that gets data from database:
PHP Code:
<div class="citylist fl">
<div class="inner_top1"></div>
<div class="inner_center1">
<ul class="country_list">
<?php
if(mysql_num_rows($resultSet)>0)
{
while( $row = mysql_fetch_array($resultSet))
{
?>
<li class="fl"><a href="javascript:;" title="<?php echo ucfirst(html_entity_decode($row['cityname'], ENT_QUOTES)); ?>" onclick="javascript:citySelect('<?php echo DOCROOT; ?>','<?php echo CURRENT_THEME; ?>','<?php echo $row['cityid']; ?>','<?php echo html_entity_decode($row['cityname'], ENT_QUOTES); ?>','<?php echo html_entity_decode($row['city_url'], ENT_QUOTES); ?>');" ><?php echo ucfirst(html_entity_decode($row['cityname'], ENT_QUOTES)); ?></a></li>
<?php
}
}
?>
</ul>
</div>
<div class="inner_bottom1"></div>
</div>