roster.php?id=1

mysql_query

Hi.

I have a mysql db, and a php script to list the rows in it. I want to show some columns (on the roster.php). If the user will want to see the rest, I want to have them click on number in the chart on that page. Wen that happens, I want to open up a small window to display the rest of the columns. So, how do i do that? If someone can give me a code or tutorial, that would be nice.
Here's the code for roster.php:

<html>
<head><title>VA Automated Roster</title><head>
<body>
<table align="center" cellspacing="0" cellpadding="0" border="1" width="80%">
<tr>
<td bgcolor="black"><font color="white">Callsign</td>
<td bgcolor="black"><font color="white">NAME</td>
<td bgcolor="black"><font color="white">EMAIL</td>
<td bgcolor="black"><font color="white">EXPERIENCE</td>
<td bgcolor="black"><font color="white">LAST FLIGHT ID</td>
</tr>
<?php
$db = mysql_connect("freesql.org","freedude","neptun");
mysql_select_db("freedude",$db);;
$sql="SELECT * FROM roster ORDER BY callsign";
$res=mysql_query($sql, $db);
while ($ligne = mysql_fetch_object ($res)) 
{
    print "<tr>";
    print "<td>$ligne->callsign</td>";
    print "<td>$ligne->name</td>";
    print "<td>$ligne->email</td>";
    print "<td>$ligne->hours</td>";
    print "<td>$ligne->last_flt</td>";	
    print "</tr>";
}
mysql_free_result ($res);
?>
</table>
</body>
</html>

Thanks.

Query.

gid

You can use a link like this:

<a href="javascript:window.open('detail.php?id=1', '_blank','toolbar=0,location=0,directories=0,status=0,menubar=0,resizable=1,scrollbars=1,width=640,height=480');void(0);">details</a>

mysql_query

Hello. Thanks for the reply.

From what I understand, this is the script to open a new window. The thing I don't understand is, I want diffrent row information on every diffrent '$callsign' I press in my roster. Your script says "a href="roster.php?id=1""

What changes should be made to my roster.php?

Thanks.

Query.

gid

change this:
print "<td>$ligne->callsign</td>";

to put something like this:
print "<td><a href="javascript....>$ligne->callsign</a></td>";

Replace the 'display.php?id=1' in my previous comment with something like this:

'display.php?callsign=$ligne->callsign'