whats going on here????????
line 52 is: echo "<option value='$rr->categoryName'>$rr->categoryName</option>";
Code: Select all
<?php
require_once("function.php");
getDbConnection();
?>
<script language="javascript" type="text/javascript" src="http://www.allfoodmenu.com/admin/script/validate.js"></script>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Admin Home</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<style media="all" type="text/css">@import "css/all.css";</style>
</head>
<body>
<div id="main">
<div id="header"><a href="index.php" class="logo"><img src="img/logo.gif" width="101" height="29" alt="" /></a>
<br />
<div align="right">
Welcome Admin <b><?php echo $_SESSION['ufname']; ?></b> | <?php echo date("Y-m-d"); ?> | [<a href="logout.php" class="nav">LOGOUT</a>] </div>
<ul id="top-navigation">
<li class="active"><span><span>Homepage</span></span></li>
</ul>
</div>
<div id="middle">
<div id="left-column">
<?php require_once("adminleftmenu.php"); ?>
</div>
<div id="center-column">
<div class="top-bar">
<div class="breadcrumbs"><a href="home.php">Homepage</a>-> <a href="bot.php">Bot</a></div>
</div><br />
<form method="post" action="bot2.php">
<select name="State">
<?
$rs = mysql_query("SELECT id FROM countries ORDER BY name ASC") or die(mysql_error());
while($country = mysql_fetch_object($rs))
{
$q=mysql_query("SELECT name from states WHERE country_id='$country->id") or die(mysql_error());;
while($r=mysql_fetch_object($q))
{
echo "<option value='$r->name'>{$country->name'] => $r->name</option>";
}
}
?>
</select>
<select name="type">
<?php
$qq=mysql_query("Select * from res_category");
while($rr=mysql_fetch_object($qq))
{
echo "<option value='$rr->categoryName'>$rr->categoryName</option>";
}
?>
</select>
<input type='Submit' value='go'>
</form>