"; echo "Email:
"; echo "
"; echo "Password:
"; echo "
"; echo ""; echo ""; } else { mysql_connect("localhost","aggregator","secret"); mysql_select_db("rssfeeds"); $email = $_POST['email']; $pswd = md5($_POST['pswd']); $query = "SELECT rowID, email, pswd FROM user WHERE email='$email' AND '$pswd'"; $result = mysql_query($query); if (mysql_numrows($result) != 1) { echo "

Could not login!

"; } else { list($rowID, $email, $pswd) = mysql_fetch_row($result); $_SESSION['userid'] = $rowID; } mysql_close(); } // end isset[email] } if (isset($_SESSION['userid'])) { mysql_connect("localhost","aggregator","secret"); mysql_select_db("rssfeeds"); require_once("rss_fetch.inc"); $userID = $_SESSION['userid']; $query = "SELECT rss.title, rss.url FROM rssfeed AS rss, user_to_rss_feed as userrss WHERE userrss.userid='$userID' AND rss.rowID=userrss.rssid"; $result = mysql_query($query); while(list($title,$url) = mysql_fetch_row($result)) { $url = "$url"; $rss = fetch_rss( $url ); echo "Channel Title: " . $rss->channel['title'] . "

"; echo "

"; } mysql_close(); } ?>