medlems liste med mysql
hej ville gerne have hjælp til en medlemsliste med oplysninger fra min database. som en liste men det er somom den ikke tager alle med kun user men ikke de andre oplysningermin table ser således ud:
CREATE TABLE loginloge (
id int(11) NOT NULL auto_increment,
user varchar(100) NOT NULL default '',
pass varchar(100) NOT NULL default '',
email varchar(50) NOT NULL default '',
alder varchar(50) NOT NULL default '',
bopael varchar(50) NOT NULL default '',
tlf varchar(50) NOT NULL default '',
tid varchar(50) NOT NULL default '',
KEY id (id)
) TYPE=MyISAM;
mit script:
<?PHP
mysql_connect("localhost", "bruger", "kode");
mysql_select_db("db");
?>
$sql = mysql_query("SELECT id, email, tlf, bopael, alder, user, date_format(tid, '%e/%c %Y, %H:%i') as tid FROM loginloge ORDER by user asc");
while($row = mysql_fetch_array($sql)) {
echo "<table width='400'>
<tr>
<td colsan='2'><h3>$row[user]</h3></td>
</tr>
<tr>
<td width='100' height='20'><font face='verdana' size='-2'>Oprettet:</td>
<td width='200'><font face='verdana' size='-2'>$row[tid]</font></td>
<tr>
<tr>
<td width='100' height='20'><font face='verdana' size='-2'>Alder:</td>
<td width='200'><font face='verdana' size='-2'>$row[alder]</font></td>
<tr>
<tr>
<td width='100' height='20'><font face='verdana' size='-2'>Bopæl:</td>
<td width='200'><font face='verdana' size='-2'>$row[bopael]</font></td>
<tr>
<td width='100' height='20'><font face='verdana' size='-2'>E-Mail:</font></td>
<td><font face='verdana' size='-2'><a href='mailto:$row[email]'>$row[email]</a></font></td>
</tr>
<tr>
<td width='100' height='20'><font face='verdana' size='-2'>Telefon:</td>
<td width='200'><font face='verdana' size='-2'>$row[tlf]</font></td>
<tr>
</table>
";
}
if($id == NULL){
echo "";
}
?>
