roster.php?callsign=1

mysql_query

I posted this before but it got delted.

Anyway, i have a script that pulls rows out of databases, but does not display all columns. I want it to display columns only after the of of the columns is clicked on. I want a small window to open with all the columns in that row. What changes to i need to make to my roster.php? Here it is:

<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("localhost","username","password");
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>

JDcrack

Hmmm....
Sounds like you need someone to write a script for you.

Try these links:
http://scriptlance.com
http://e-lance.com

mysql_query

Yes, I'm learning PHP.

I don't need people to write scripts for me, I need people to help me write scripts. That's what these forums are all about.

Thanks for the reply, anyone else?

BTW, if someone reccommends a good tutorial on this thing, that'll be good as well.

Thanks.

JDcrack

This post is very vague.....
Currently you are only printing out these colomns:
callsign
name
email
hours
last_flt

You say you want to print all columns?
Add any columns (fields) in your table by ading them to your loop:
print "<td>$ligne->last_flt</td>";

print "<td>$ligne->column_name</td>";
print "<td>$ligne->column_name</td>";
print "</tr>";

If you are new to PHP and MySQL here are some links that will help you:
http://www.php.net/manual/en/tutorial.php
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html
http://www.devshed.com/Server_Side/PHP/PHPMySQLPublishing/page1.html
http://www.freewebmasterhelp.com/tutorials/phpmysql/
http://www.phpbeginner.com/columns/joel/mysql
http://www.newbienetwork.net/content.php?id=10

But Above All....
http://php.net
http://mysql.com

greg252

after the of of the columns is clicked on???

From what I understand, you need two queries.
One to display the inital table with whatever you want dispalyed with one of the cells as a link to the secondary page passing a variable to the second query.
Something within the while loop as:
<a href=nextpage.php?id=$id>$col</a>
where $col is the name looping from the db
Kinda easy if you have an auto increment col as an index.

Good luck,
Greg

[deleted]

If I am understanding correctly, you want expanded information on a particular listing. This is one way to do it.

function openWindow() {
popupWin = window.open('details.php', 'remote', 'scrollbars,width=400,height=200')
}

// details.php being a file that will call the db for the additional
//info you desire and place it in a small 400 pixel window
// done hiding -->
</script>

<? PHP Code...

{
print "<tr>";
print "<td><a href='javascript:openWindow();'>$ligne->callsign</A></td>";
print "<td>$ligne->name</td>";
print "<td>$ligne->email</td>";
print "<td>$ligne->hours</td>";
print "<td>$ligne->last_flt</td>";

print "</tr>";
}

</BODY>
</HTML>

NiXXeD

I think maybe what he was asking was how to have the page show only the columns selected by user input based on the javascript window. Just use your GET vars... IE:
www.whatever.com/whatever.php?column1=1&colum2=1

and for your table stuff just do this or something of the sort:
echo (isset($GET["column1"]) && $GET["column1"]==1) ? "<td>$ligne->column_name</td>" : "<td></td>";