[Resolved] php with mysql help

[sumday]

right now i'm making an online rpg with usernames and passwords stats including hp mana ect. My problem is i cant figure out how to print data from my database with specific user info. I made a stats page for my site which shows all of the users and their stats located here, but i cant seem how to figure out how to print data for only one user instead of listing all of the users. Could somebody please tell me how to make it so i can just print one user instead of all of them using php.

[stolzyboy]

do it with your sql statements

$query = "select * from tablename where fieldname = "whatevervalue";

i usually pass id's thru the query string like

<a href="page.php?id=4">click</a>

then your $query would look like

$query = "select * from tablename where idfieldfromdb = " . $_GET['id'] . ";";

and i'm assuming you know the rest, since you got what you have working

[Trs2988]

You're going to want to put a where clause onto the end of your select statement.

Suppose your table name is "users", and they are identified by the column "id". You would access your stats page by going to stats.php?id=1, and this the code for it:

<?php
$result = mysql_query("select *  from users where id=$id");
$row = mysql_fetch_assoc($result);
extract($row);
echo "Stats stuff goes here...";
?>

I hope this helps.