Selecting a row

[Machin]

Well, Im new to this whole thing of PHP, so, be patient with me :p

Ok, I have a database with records, and I show these records in a Table with this code:

echo "<table border='1'>

<tr>
<th>Name</th>
<th>Department</th>
<th>Login</th>
<th>Employee ID</th>
<th>Active</th>
</tr>";while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['department'] . "</td>";
echo "<td>" . $row['login'] . "</td>";
echo "<td>" . $row['employee_id'] . "</td>";
echo "<td>" . $row['active'] . "</td>";

echo "</tr>";
}
echo "</table>";mysql_close($con);

I have three buttons after this code (add, delete and edit).

I want to be able to select one row of the table, and send the data in the cells to another php file when I click Edit or Delete, but I have no idea on how to do this. If you have any idea or some help, that would be great. I dont know if I explain this in a good way, if not, I'll try to do it in a better way.

So, thx in advance.

[Frederick]

echo "<td><a href=\"yourpage.php?employeeid=".$row['employee_id']."\">".$row['name']."</a></td>";

On the next page, use:

<?php
if ($employeeid>0) {
/*sql stuff here*/
}
?>

[Machin]

Hey, thx for the answer, and it works, but not as the way I expected, also I noticed i did not explain very well myself 🙁

After the name is click, its supposed to take you to another file with an HTML form, and i wanted to show the info on the inputs, I tried to make this happen, but with no success. So if anybody has any idea, thx in advance again.

LaterZ

/////////////////////
EDIT: I have found the anwser =).

LaterZ

[Frederick]

Check out functions at php.net

mysql_connect()
mysql_select_db()
mysql_query()
mysql_fetch_array()

ie:

<input type="text" name="yourname" value="<?php echo $row['yourname'];?>" size="30">