print row from database

[buckeyejack]

Ok
Here we go. I have 10 tables, each stand for a department.
Inside the table = employees, date hired, personal info etc.
I have it to where if you enquire about the dept. you get the names in the dept. , but I need the names to be hyperlinks to the row in the database which contains all fields.

I'm looking for a way that one script does it all. Some depts. have hundreds which would be hard to write individual scripts.
Open for suggestions as well.
Thanks (:>)
matt

[jcleary]

Unless you have a good reason not to, the first thing I would do is put all personnel into one database, and add a field for department. This is pretty straight forward "read the manual" stuff, however heres an exmaple

<? if ($employee_id <> "") {

$qry = mysql_select("select * from table where employee_id = $employee_id");
$row = mysql_query_array($qry);

echo $row["lastname"] ." - ". $row["firstname"];
etc...

} else {

$qry = mysql_select("select * from table");

while($row = mysql_query_array($qry)) {
echo "<a href='employee.php?employee_id=".$row["employee_id"]."'>";
echo $row["lastname"];
echo "</a></br>/n"

}
}

[toma42]

You need to redo your database. You need

Employee with a ref to departments or a xref table to department

Department

Tell me this: how are you going to move someone between departments? What happens if you need a new column in the users info.

Once you fix this root problem, this one will go away.

Tom