Masterhilfe.de Thema anzeigen

Terron · Junior-Member

Hi,

wir haben bisher ein Membersscript, das so aufgebaut ist:

<?php

if(!isset($id))
{
$content->addHeadline("Members",5);

$content->addRow(5);

$members= db_query("SELECT id, nick, email, icq FROM member");

$content->add("<tr>
<th>Nick</th>
<th>E-Mail</th>
<th>ICQ</th>
<th>Details</th>
</tr>");

while($member = db_fetch_array($members))
{
$content->addSpace(10);

$content->add("<tr>
<td class='center'>".$member['nick']."</td>
<td class='center'><a href='mailto:".$member['email']."'>".$member['email']."</a></td>
<td class='center'>");
if($member['icq']!='') $content->add("<a href='http://web.icq.com/whitepages/add_me?uin=".$member['icq']."&action=add' target='_blank'><img border='0' src='http://wwp.icq.com/scripts/online.dll?icq=".$member['icq']."&img=5'></a>");
$content->add("</td>
<td class='center'><a href='?nav=members&id=".$member['id']."'>details</a></td>
</tr>");
}

$content->addRow(5);
}
else
{

$members= db_query("SELECT * FROM member WHERE id=".$id."");

if(db_num_rows($members)!=1)
{
$content->addTR("dieser member existiert nicht");
}
else
{
$member = db_fetch_array($members);

$content->addHeadline($member['nick']);
if($member['real_name']!='') $content->addTR("Real Name</td><td>".$member['real_name']);
if($member['geburtsdatum']!='') $content->addTR("Geburtsdatum</td><td>".$member['geburtsdatum']);
if($member['geschlecht']!='') $content->addTR("Geschlecht</td><td>".$member['geschlecht']);
$content->addTR("Position</td><td>".$member['position']);
$content->addTR("E-Mail</td><td><a href='mailto:".$member['email']."'>".$member['email']."</a>");
if($member['icq']!='') $content->addTR("ICQ</td><td><a href='http://web.icq.com/whitepages/add_me?uin=".$member['icq']."&action=add' target='_blank'><img border='0' src='http://wwp.icq.com/scripts/online.dll?icq=".$member['icq']."&img=5'></a>");
}

}

?>

Ich würde dort gerne einmal Überschriften einfügen (welche Games wer spielt). In dem Feld Posizion habe ich immer eingetragen wer was spielt.
Dann sollen in diesen Überschriften die Namen sortiert werden. (Alphabetisch aufsteigend)

Kann mir jemand den Code hier herein posten?
Danke

Terron

RW · Junior-Member

HI
$members= db_query("SELECT * FROM member WHERE id=".$id."");

$members= db_query("SELECT * FROM member WHERE id=".$id." order by ".was_du_möchtest." ");

order by

Feldbezeichnung NAME ?

Grüße
RW