Why does the following code refuse to work (displaying results from a mysql

G

Grizzley g

New member
database using PHP)? Nothing is "echoing" with the following code; please help. :(

<?php
$Name = (isset($_POST["Name"])) ?$_POST["Name"]:"";
$HasSite = (isset($_POST["HasSite"])) ?$_POST["HasSite"]:"";
include('connection.php');
$sql = "SELECT * FROM table";
$result = mysql_query($sql);
$mypost = mysql_fetch_array($result);

if ($mypost) {
$name = $mypost["name"];
$hassit = $mypost["hassit"];
}
?>
<html><head><title>Page</title><link rel="somecss" href="somelink"></head>
<body>
<div id="left">
<form method ="post" action="<?php echo $_SERVER["PHP_SELF"] ?>" >
<ol>Sort by:
<li><input type="submit" value="Name" /></li>
<li><input type="submit" value="HasSite" /></li>
</ol>
</div>
<div id="right">
<?php if ($mypost) {
if ($Name) {
do {echo $name .":". $hassit;
} while ($myposts = mysql_fetch_array($result));
} else if ($HasSite) {
do {echo $hassit .":". $name;
} while ($myposts = mysql_fetch_array($result));
} else {
echo mysql_error();
}
}
?>
</div>
</body>
</html>
 
Back
Top