Help!

ctsttom

Hey all, this is my first post and im sure the question im asking has been asked b4 but i have no idea what to look for and its too big to go thru every post in the forums....

Im new to php and im trying to get to grips with it by writing a members database (at the moment im writting the admin part) and ive got it displaying a list of all users and there are 3 options (details, edit, delete) and i am working on the details part (which is on details.php) at the mo, the details part displays the full member profile but i dont know how to make my php display only the member profile i choose (i do have a id key but how do i make it display only one record not all of them?) heres the code i've done so far...

CODE:

<html>
<head>
<title>Members List</title>
</head>
<body>
<?php
// Connect to the database server
$dbcnx = @mysql_connect("localhost", "dbaccess", "1234");
if (!$dbcnx) {
echo( "<p>Unable to connect to the " .
"database server at this time.</p>" );
exit();
}
// Select the jokes database
if (! @mysql_select_db("communitydb") ) {
echo( "<p>Unable to locate the joke " .
"database at this time.</p>" );
exit();
}
?>
<p> Member Details:</p>
<?php

// Request the text of all the jokes
$result = @("SELECT * FROM members");
if (!$result) {
echo("<p>Error performing query: " . mysql_error() . "</p>");
exit();
}
// Display the text of each joke in a paragraph
while ( $row = mysql_fetch_array($result) ) {
echo("<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">");
echo(" <tr> ");
echo(" <td width=\"50%\">");
echo("<div align=\"right\">Username:</div></td>");
echo(" <td>" . $row["username"] . "</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\">");
echo("<div align=\"right\">Password:</div></td>");
echo(" <td>" . $row["password"] . "</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\">");
echo("<div align=\"right\">DOB:</div></td>");
echo(" <td>" . $row["dob"] . "</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\">");
echo("<div align=\"right\">Email:</div></td>");
echo(" <td>" . $row["email"] . "</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\">");
echo("<div align=\"right\">Newsletter:</div></td>");
echo(" <td>" . $row["newsletter"] . "</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\">");
echo("<div align=\"right\">AIM:</div></td>");
echo(" <td>" . $row["aim"] . "</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\">");
echo("<div align=\"right\">ICQ:</div></td>");
echo(" <td>" . $row["icq"] . "</td>");
echo(" </tr>");
echo(" <tr>");
echo(" <td width=\"50%\">");
echo("<div align=\"right\">MSN:</div></td>");
echo(" <td>" . $row["msn"] . "</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\">");
echo("<div align=\"right\">YIM:</div></td>");
echo(" <td>" . $row["yim"] . "</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\">");
echo("<div align=\"right\">Permissions:</div></td>");
echo(" <td>" . $row["permissions"] . "</td>");
echo(" </tr>");
echo("</table>");
}
?>
<p align="center">Edit / Delete</p>
</body>
</html>

sijis

all you have to do is change this line

$result = @("SELECT * FROM members");

to something like this:

$result = @("SELECT * FROM members WHERE id = $id");

id is the field in your database which is the member's id.
$id is the value of that member id you want.

you can give $id a value a number of different ways...
either a form or through a querystring.

querystring example:
the 'view' link would be like this

User1 (view) | file.php?member_id=1
User1 (view) | file.php?member_id=2
etc ...
then in you would get the value like this in file.php

$id = $_REQUEST['member_id'];

form example...

then in your file.php you would do this:
$id = $_POST['member_id'];

ctsttom

thx m8 it worked!