Table and data linking

Anon

So, here`s my problem.
I have a table and it contains fname, lname, adr etc.
I want a list ordered by lname, and all lnames are created as links. So if I click on lname, a new window with forms filled with info of that name(adr,fname,etc)will open.Then I can change info in form and update this particular name information.

How to do that?

mosizlak

are you using a mysql? if so you might be able to use this:

//****************************************

<TABLE border=1 cellpadding=15pixels>
<TR>
<TD align="center" valign="top">
Select a name.
<BR><BR>
</TD>
</TR>

<?php

$db_host = 'yourhost';
$db_user = 'youruser';

$db_pass = 'yourpassword';
$db_name = 'yourdbname';

$db_table = 'yourtablename';

$conn = mysql_connect($db_host,$db_user);

if ($conn == true)
{
mysql_select_db($db_name,$conn);

$q_result = mysql_query("select yourstuff where yourformname'sinput=yourtablekey" , $conn);

while($row = mysql_fetch_array($q_result))
{
print "<option value='$row[0]'>$row[0]</option>\n";
}
}
else
{
echo 'Could not connect to database : '. mysql_error();
exit();
}

mysql_close();

</SELECT>
</TD>

//****************************************

This code produces a select box filled in with values from a mysql table. What you'd need to do (I think anyway - I'm no html expert) is stick some html stuff in the option tag to turn your $row variable into a href or something.

Hope this isn't useless . . . good luck!