Im making a dynamic form using some simple ajax, but having the hardest time in the world making it work properly.
Here is the code:
<html>
<?
include '/data1/carma/includes/config.php';
mysql_connect($config['DB_SERVER'], $config['DB_USER'], $config['DB_PASSWORD']);
mysql_select_db($config['DB_DB']);
?>
<head>
<title>TSG - Carma Content Editor</title>
<script type="text/javascript" src="includes/jscripts/form.js"></script>
<link rel="stylesheet" type="text/css" href="includes/jscripts/style.css">
</head>
<body>
<form method=post name=f1 action="index.php"> <input type=hidden name=do value=update>
<span class="title">Select A Site</span><br>
<select name="siteid" onchange="reload(this.form)" class="text">
<option value="">Select Site</option>
<?
// get the information for the drop down menu from sites
$q = mysql_query('SELECT * FROM sites');
while ($arr = @mysql_fetch_assoc($q)) {
if($arr['siteid']==@$siteid){
?>
<option value="<?=$arr['siteid']; ?>"> <?=$arr['name']; ?></option>
<? } else { ?>
<option value="<?=$arr['siteid']; ?>"> <?=$arr['name']; ?></option>
<? } ?>
<? } ?>
</select>
<br><br>
<?
// get number of rows and run query for all gals on the site specified by siteid
if(isset($_GET['siteid']) and strlen($_GET['siteid']) > 0){
$q2 = mysql_query('SELECT * FROM cms_gal_sites WHERE siteid='.$_GET['siteid']);
$q2_num = @mysql_num_rows($q2);
} else {
$q2 = mysql_query('SELECT * FROM cms_gal_sites WHERE siteid='.$_GET['siteid']);
$q2_num = @mysql_num_rows($q2);
}
// if there is a site, but no content then either display the content or display the error
if (($_REQUEST['siteid']>0) && ($q2_num!==0)) {
$site_q = mysql_query('SELECT * FROM sites WHERE siteid='.$_GET['siteid']);
$row = @mysql_fetch_assoc($site_q);
?>
<span class="title">Select Content From <?=$row['name']; ?></span><br>
<select id="ajaxmenu" size="1" onChange="ajaxcombo('ajaxmenu', 'contentarea')">
<option value="">Select Set</option>
<?
// pull caption information for each gal or video
while ($arr2 = mysql_fetch_assoc($q2)) {
$query3 = mysql_query('SELECT * FROM cms_gals WHERE galid='.$arr2['galid']);
$qarr3 = @mysql_fetch_assoc($query3);
?>
<option value=edit.php> <?=$qarr3['caption']; ?></option><br>
<? } ?>
</select>
<? } else if (($_REQUEST['siteid']>0) && ($q2_num==0)) { ?>
<span class="title">Sorry, No Content Available For Editing!</span><br><br>
<? } else { ?>
<span class="title">Waiting for site selection.</span><br>
<? } ?>
</form>
<br>
<br>
<div id="contentarea"><h3>Choose a page to load.</h3></div>
<div style="clear: left; margin-bottom: 1em"></div>
</body>
</html>
says javascript error line 31