cffrost2 - 12:43 pm on May 5, 2012 (gmt 0)
You used this
echo ' username:'.$username;
echo ' username is empty';
echo ' firstname:'.$firstname;
echo ' Firstname is empty';
echo ' maidenname:'.$maidenname;
echo ' maidenname is empty';
and got this
username:Scotty lastname: maidenname is empty
or did you change one to test the lastname? If so, you can see you firstnam var is not empty. Your lastname var is not empty but has no real value (possibly a space?). And maidenname has no value. Either pulled wrong from the db or there isn't anything there to get.
Your next step should be to check your db values and see if they exist. Then check your SQL query statement and make sure it's right.