PHP and MYSQL

[nazariah]

i have one database name login. In this login db i have 3 tables, login, filename and inter_section.
i have create user accounts for data entry screen.
my problem now is how can i display data(in mySQL) to PHP table base on userid. I mean i don't want my display screen show all the data in database. i want an ex: if lisa login, only data lisa display. when john login, only data john display. i already used select commands but it doesn't work.
plz help me...
tq.

[Anon]

"ex: if lisa login, only data lisa display"

Use this for your mysql command:

$inquiry = mysql_query("SELECT * FROM table_name WHERE user='Lisa'", $db);

Then to use the info using php:

$a = mysql_fetch_array($inquiry);
$name = $a[name];
$password = $a[password];
$info = $a[info];

That's pretty standard stuff there. You have to modify depending on the field names in your tables, your table names and the database name.

[nazariah]

dear hiccup,

i still have an error using that codes... i think it's caused by, userid i saved in login table and all the user data i saved in filename table...that's why i still have error...
how to concatenate between this two tables.