help with displaying individual record

[deregular]

Hi all,
A newbie here, but loving this stuff.

Im a little stuck though. and need some help.

So far I am writing a basic script to query a mysql db and return results, but am getting stuck.

Here is the main part im stuck on.
'Where ive marked #######'s.

//if you want to see employee details then display one employees details

if(isset($showdetails)){
###############
###############

}
else{

//display all employees with name and link to more details on each.

while($row=mysql_fetch_array($result)){

$id=$row["ID"];
$firstname=$row["FirstName"];
$surname=$row["Surname"];


echo("<p>$firstname" . " " . "$surname".
" <a href='$PHP_SELF?showdetails=$id'>"."See This Employees Details</a></p>");
}
}

It is a basic script to call all employees listed in a table.
I have worked out how to display all employees, but i want to be able to click on the employee name and be taken to more detailed results on that employee... I am using $PHP SELF to take it back to the same page with the url determining the ID of the row.
How do i show the employee details of the employee i clicked on?
thanks in advance!

[drawmack]

$sql = "SELECT * FROM <table> WHERE <id> = " . $_GET['id'];

replace the <> information with the actual information from your databse.

[deregular]

thanks drawmack,
but how do i process to echo to screen?
for the moment i will just echo the firsname and surname of one person, I will add extra employee details later.

here it is so far. #####'s where i need assistance.
thanks again.

<?php
include"header.php";
require"config.php";

//connect to db using config.php if no connect then error.
$cnx=mysql_connect("localhost",$dbuser,$dbpasswd);
if(! $cnx)
	die("Couldnt connect to db");
mysql_select_db($dbname, $cnx)
	or die("Couldnt open $dbname:".mysql_error());

//get info from table Employees if no table connect then error.
$result=mysql_query("SELECT ID, FirstName, Surname FROM Employees");

if(!$result){
	echo("<p>Error performing query: ". "mysql error()" . "</p>");
exit();
}

//if you want to see employee details then display one employees details

if(isset($showdetails)){
$sql = "SELECT * FROM Employees WHERE ID = " . $_GET['id']; 
#############
}
else{

//display all employees with name and link to more details on each.

while($row=mysql_fetch_array($result)){

$id=$row["ID"];
$firstname=$row["FirstName"];
$surname=$row["Surname"];


echo("<p>$firstname" . " " . "$surname".
" <a href='$PHP_SELF?showdetails=$id'>"."See This Employees Details</a></p>");
}
}

include"footer.php";
?>

[deregular]

sorry, double posted.......

[drawmack]

process it the same way as you do for all the results but you'll only have one result in this query.

[deregular]

i must just not be learning as quickly as i thought as i still cant get it to work.

Database = Employees
Fields = ID, FirstName, Surname

what am i doing wrong?

<?php
include"header.php";
require"config.php";

//connect to db using arrays from config.php if no connect then error.
$cnx=mysql_connect("localhost",$dbuser,$dbpasswd);
if(! $cnx)
	die("Couldnt connect to db");
mysql_select_db($dbname, $cnx)
	or die("Couldnt open $dbname:".mysql_error());

//get info from table Employees if no table connect then error.
$result=mysql_query("SELECT ID, FirstName, Surname FROM Employees");

if(!$result){
	echo("<p>Error performing query: ". "mysql error()" . "</p>");
exit();
}

//if you want to see employee details then display one employee's details

if(isset($showdetails)){
$sql="SELECT * FROM Employees WHERE ID = " . $_GET['id']; 

$firstname=$sql["FirstName"];
$surname=$sql["Surname"];

//just to text if it works
echo("$sql[Surname]");
echo("$surname");
//neither of these work, Im only getting a single "S"showing.

}
else{

//display all employees with name and link to more details on each.

while($row=mysql_fetch_array($result)){

$id=$row["ID"];
$firstname=$row["FirstName"];
$surname=$row["Surname"];


echo("<p>$firstname" . " " . "$surname".
" <a href='$PHP_SELF?showdetails=$id'>"."See This Employees Details</a></p>");
}
}

include"footer.php";
?>

[drawmack]

after $sql = ...
do $query = mysql_query($sql);
then $row = mysql_fetch_assoc($query);
Then yuo'll be able to use $row the way you're trying to use $sql.

[deregular]

not working, all im seeing is a error.
Warning: Supplied argument is not a valid MySQL result resource .

it has a problem with-
$row = mysql_fetch_assoc($query);

Here is what I have:

<?php
include"header.php";
require"config.php";

//connect to db using arrays from config.php if no connect then error.
$cnx=mysql_connect("localhost",$dbuser,$dbpasswd);
mysql_select_db($dbname,$cnx);


//if you want to see employee details then display one employee's details

if(isset($showdetails)){
$query="SELECT * FROM Employees WHERE ID = " . $_GET['id'];  

$result = mysql_query ($query);


$row = mysql_fetch_assoc($result);


$firstname=($sql['FirstName']);
$surname=($sql['Surname']);


echo("$firstname");

}else{

//get info from table Employees if no table connect then error.
$result=mysql_query("SELECT * FROM Employees");

if(!$result){
echo("<p>Error performing query: " . "mysql error()" . "</p>");
exit();
}
//display all employees with name and link to more details on each.

while($row=mysql_fetch_array($result)){

$id=$row["ID"];
$firstname=$row["FirstName"];
$surname=$row["Surname"];


echo("<p>$firstname" . " " . "$surname".
" <a href='$PHP_SELF?showdetails=$id'>"."See This Employees Details</a></p>");
}
}

include"footer.php";
?>

[deregular]

yeeehaaaa, i worked it out,
thanks drawmack for leading me in the right direction my friend.

heres what i did....
Turns out i hadnt assigned the $id
from the previous page, i presumed it would pass through.
$id=$_GET['showdetails'];

<?php
include"header.php";
require"config.php";

//connect to db using arrays from config.php if no connect then error.
$cnx=mysql_connect("localhost",$dbuser,$dbpasswd);
mysql_select_db($dbname,$cnx);

//if you want to see employee details then display one employee's details

if(isset($showdetails)){

$id=$_GET['showdetails'];

$result=mysql_query("SELECT * FROM Employees WHERE ID=$id");
$row=mysql_fetch_array($result);

$name="$row[FirstName]";
$surname="$row[Surname]";
$phone="$row[Phone]";
$cell="$row[Cell]";
$address="$row[Address]";
$city="$row[City]";
$state="$row[State]";
$zip="$row[Zip]";
$country="$row[Country]";

echo("<b>Name:</b> $name"." $surname<br>".
"<b>Phone:</b> $phone<br>".
"<b>Cell:</b> $cell<br>".
"<b>Address:</b> $address<br>".
"<b>City:</b> $city<br>".
"<b>State:</b> $state<br>".
"<b>Zip:</b> $zip<br>".
"<b>Country:</b> $country<br>");

}else{

//get info from table Employees if no table connect then error.

$result=mysql_query("SELECT * FROM Employees");

if(!$result){
echo("<p>Error performing query: " . "mysql error()" . "</p>");
exit();
}
//display all employees with name and link to more details on each.

while($row=mysql_fetch_array($result)){

$id=$row["ID"];
$firstname=$row["FirstName"];
$surname=$row["Surname"];

echo("<a href='$PHP_SELF?showdetails=$id'>"."$firstname"." $surname</a><br>");
}
}

include"footer.php";
?>