Update of /cvsroot/openfirst/members
In directory sc8-pr-cvs1:/tmp/cvs-serv17487
Modified Files:
profile.php
Added Files:
photo.png
Log Message:
Add ordering to members profiles
--- NEW FILE: photo.png ---
(This appears to be a binary file; contents omitted.)
Index: profile.php
===================================================================
RCS file: /cvsroot/openfirst/members/profile.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** profile.php 23 Jul 2003 22:20:15 -0000 1.7
--- profile.php 23 Jul 2003 22:46:30 -0000 1.8
***************
*** 35,43 ****
?>
<table>
! <tr><th>User Name</th><th>Team</th><th>MSN</th><th>ICQ</th><th>AIM</th></tr>
<?php
! $query = mysql_query("SELECT user, team, msn, icq, aim FROM ofirst_members;");
while($q = mysql_fetch_object($query)) {
! echo("<tr><td><a href='profile.php?id=$q->user'>$q->user</a></td><td>$q->team</td><td>$q->msn</td><td>$q->icq</td><td>$q->aim</td></tr>");
}
?>
--- 35,50 ----
?>
<table>
! <tr><th><a href="profile.php?orderby=user">Nick Name</a></th><th><a href="profile.php?orderby=team">Team</a></th><th><a href="profile.php?orderby=email">E-mail</a></th><th><a href="profile.php?orderby=msn">MSN</a></th><th><a href="profile.php?orderby=icq">ICQ</a></th><th><a href="profile.php?orderby=aim">AIM</a></th><th><a href="profile.php?orderby=picturelocation">Photo</th></tr>
<?php
! if($_GET["orderby"] == "") { $_GET["orderby"] = "user"; }
! $query = mysql_query("SELECT * FROM ofirst_members where " . $_GET["orderby"] . " is NOT NULL ORDER BY " . $_GET["orderby"] . ";");
while($q = mysql_fetch_object($query)) {
! echo("<tr><td><a href='profile.php?id=$q->user'>$q->user</a></td><td>$q->team</td>");
! if($q->email != "") { echo("<td><img src='email.png' alt='email available' /></td>"); } else { echo("<td></td>"); }
! if($q->msn != "") { echo("<td><img src='msmsgs.png' alt='msn available' /></td>"); } else { echo("<td></td>"); }
! if($q->icq != "") { echo("<td><img src='icq.png' alt='icq available' /></td>"); } else { echo("<td></td>"); }
! if($q->aim != "") { echo("<td><img src='aim.png' alt='aim available' /></td>"); } else { echo("<td></td>"); }
! if($q->picturelocation != "") { echo("<td><img src='photo.png' alt='photo available' /></td>"); }
! echo("</tr>");
}
?>
|
