"; } 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 '

0 Ideas

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