//echo $query3."<BR>";
$result3 = mysql_query($query3) or die("Failed Query of " . $query3);
echo "DELETED TEST VIEW...<BR>";
//now read to create new view with old name
$result4 = mysql_query($viewcode) or die("Failed Query of " . $viewcode);
echo "output: " . $result4;
echo "<BR>SUCCESSFULLY CREATED NEW VIEW<BR>";
}
?>
<form name="listviews" action="editview.php" method=POST>
<table>
<tr><td><select name="views" onchange="this.form.submit();">
<!-- <tr><td><select name="views" onclick="myalert();"> -->
<?php
$column_name = "Tables_in_" . db_utility::get_database();
echo "<option value=\"1\">--select a view--</option>";
for ($j = 0; $j < mysql_num_rows($result1); $j++) {
$row1 = mysql_fetch_array($result1);
echo "<option value=\"" . $row1[$column_name] . "\"";
if (isset($_POST['views'])) {
if ($row1[$column_name] == $_POST['views']) {
echo "selected";
}
}
echo ">" . $row1[$column_name] . "</option>";
}
?>
</select></td></td>
<tr><td><input type="hidden" value="Submit" name="Submitform" /></td></tr>
</form>
