[tisza]

ok, i am having trouble displaying variables form a databse, i downlaoded a login script from http://www.hotscripts.com/Detailed/26782.html, the login and stuff works fine, it stores the variables in the database, the only thing is i cant figure out how to display them, when you login in i want it to display all your info, i changed it so when u log in it redirects you to a page, i just dont know what to put on the page so it displays them, i have included the connect.php which ocnnects to the database, i just dont know how to display the variables once you log in, thanx

(if you need any mroe info like sources just post)

[Beaver]

Check out the mysql_query, and mysql_fetch_row functions to grab the info you want. I'd recommend you check out the online php docs, and some tutorials, which can be searched for via google.

[tisza]

can you kind of give me a breif run through, most tutorials are over my head

[NeverMind]

just provide us with table structure and we will handle it

[NerdRUS]

you could have something like this where the valid_user is the variable you carry throughout the site

$display = mysql_query("select * from members where email = '$valid_user'");
$row = mysql_fetch_array($display);


Username:&nbsp;<?php echo stripslashes($row['username']); ?></br>
E-mail:<br/><?php echo stripslashes($row['email']); ?>

[tisza]

Originally Posted by NeverMind

just provide us with table structure and we will handle it

the table that i am using?

ok well its called users and it has:

Field-----------Type--------Null-----------Extra Action
user_id---------int(11)-------No---------auto_increment
username----varchar(20)-----No
password----varchar(10)------No
email--------varchar(30)-------No

all i want to know is how to display those after you log in, like once you log in it directs you to a page, i changed it so it directs you to info.php, what do i need to put on info so that it shows you your info

[tisza]

Originally Posted by NerdRUS

you could have something like this where the valid_user is the variable you carry throughout the site

$display = mysql_query("select * from members where email = '$valid_user'");
$row = mysql_fetch_array($display);


Username:&nbsp;<?php echo stripslashes($row['username']); ?></br>
E-mail:<br/><?php echo stripslashes($row['email']); ?>

and when i do this all it displays is:

Username:
E-mail:

and nothing else

[blaw]

Hi there,

Quick check - Does your variable $valid_user contain email or username? And are you sure there is such an email (or username) stored in the database?

[tisza]

i am pretty sure its email, isnt that what it is in nerdrus's code

and its in the database, i know for a fact

[blaw]

Hi again,

Originally Posted by tisza

i am pretty sure its email, isnt that what it is in nerdrus's code

No. Look carefully - there is no part where he assigns a value to this variable, so it could contain anything. If you just copied & pasted this code, it will always give you an empty set because $valid_user will contain "" (empty string), and you are trying to match the email field to this value, but your email field does not contain an empty string.

Assign whatever the value (i.e. valid user's email) you carry throughout the site into this $valid_user, and you should be getting what you want. As to how, I can't tell you as of because I don't know what your site dynamics is.

Just to note, I'm going out for lunch now and will perhaps be back in 2 hours or so. Good luck.