"; }
if ( isset($_COOKIE["sessionID"]) ) {
$sessionID = $_COOKIE["sessionID"];
}
if ( 0 && empty($sessionID) ) {
echo "
\n"; mysql_close($con); } // end of very long "else" clause ?>
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";
echo 'Back to Interactive List' . "\n";
echo "
\n\n";
echo '0 Ideas
' . "\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' . "\n";
echo ' ';
echo ' ' . $idea . ". " . $name . '';
echo "\n" . '
\n";
}
echo "\n' . "\n";
// short description next:
$desc = $row['short_desc'];
if ( !empty($desc) ) {
echo ' ' . $desc . ' ';
}
echo "\n
\n\n"; mysql_close($con); } // end of very long "else" clause ?>