"; }
if ( isset($_COOKIE["sessionID"]) ) {
$sessionID = $_COOKIE["sessionID"];
}
if ( 0 && empty($sessionID) ) {
echo "
Ideas
";
echo "
You are not logged in.
";
} else {
//session_start ( $sessionID );
$uid = 0;
if ( isset($_SESSION['uid']) ) {
$uid = $_SESSION['uid'];
}
$admin = 0;
if ( isset($_GET['admin']) ) {
$admin = $_GET['admin'];
}
// connect to the DB and get Idea data
$con = mysql_connect("localhost","webeng","invent33");
if (!$con) { die('Could not connect: ' . mysql_error()); }
mysql_select_db("inventor-labs", $con);
echo "
\n\n";
echo '
' . "\n\n";
$query = "SELECT * FROM Ideas;";
//echo $query;
$result = mysql_query( $query );
$rowcount = 0;
while ( $row = mysql_fetch_array($result) ) {
$idea = $row['ideaID'];
$titleURL = $row['titleURL'];
if ( !$admin && !$row['public'] ) {
continue;
}
$rowcount++;
$name = $row['title'];
echo '
\n";
}
echo "\n
\n
\n";
mysql_close($con);
} // end of very long "else" clause
?>