As a final part of a three part series in how to password protect your pages with your new user database that you created from the previous posts. To do this, create a new php file called:
passprotect.php
<?php
include ‘config.php’;
$authorid = $_COOKIE["member"];
$password = $_COOKIE["memberpass"];
$SQLvalidate = “SELECT * FROM `member` WHERE memberid=’$memberid’ AND password=’$password’”;
$results = mysql_query($SQLvalidate);
$numrows = mysql_num_rows($results);
if [...]

Just today I was working on a clients WordPress install and ran into a considerable problem. I was trying to upgrade the version of WordPress from 2.1 to 2.6.2 and could imported the posts through the database import functionality (phpmyadmin). After doing the same with the comments, I thought all was set…Boy was I wrong…
The [...]