hello webmasters, i am trying to develop a social networking site but I am having problems with the login/registration section which makes it difficult to create a profile page.Although the registration submits to the database,I cant get values back to the profile page. I also intend adding lost password codes but it does not work.Plzzzzzz help me

Can u show us d code u r using in fetching d data from d database?

What social network script is that?

I created 4 PHP files

1. signup.php
2. signup_ac.php
3. confirmation.php
4. config.php

I created 2 databases

1. temp_members_db
2. registered_members
Table "temp_members_db"
CREATE TABLE `temp_members_
db` (
`confirm_code` varchar(65) NOT
NULL default '',
`name` varchar(65) NOT NULL
default '',
`email` varchar(65) NOT NULL
default '',
`password` varchar(15) NOT
NULL default '',
`country` varchar(65) NOT NULL
default ''
) ENGINE=MyISAM DEFAULT
CHARSET=latin1;

Table "registered_members"
CREATE TABLE `registered_
members` (
`id` int(4) NOT NULL auto_
increment,
`name` varchar(65) NOT NULL
default '',
`email` varchar(65) NOT NULL
default '',
`password` varchar(65) NOT
NULL default '',
`country` varchar(65) NOT NULL
default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin 1;

for a logged in user to view his personal profile...

use his cookies id/session id to get his info from the db

and then display them in the right places...

e.g if a user logs in with his correct details..i am sure u store his session..

the session might be his username or user_id or sumthing...

then when u want to fetch the user info from the DB just use the session_id

lets say his session ID is $_SESSION['username']; 

so you know as far as the user is logged in his username is available for u anywhere you call it

so u just store the value of $_SESSION['username'] to a variable

i.e $uname = $_SESSION['username'];

so you can say $qry = "SELECT * FROM user WHERE $username = '$uname'";

Don't forget to clean the variable for security purpose..

i hope i answered your question...

and you don't really need the "temp_members_db"...

just create a column(verified) in ur "registered_member_db" that holds either a "1" or "0" i.e TRUE or FALSE

A registered and verified member has a "1" on his verified column

while a registered and unverified member has "0" on his verified column

then you create a function that checks if a user is verified or not by just checking the "verified" column..

but you can do it any which way suits you sha...just helping with my own 2cents