Mysgl værdier ind i tabel

virker måske :-)

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
  <tr>
    <td>&nbsp;Charname&nbsp;</td>
    <td>&nbsp;Charclass&nbsp;</td>
    <td>&nbsp;Difficulty&nbsp;</td>
    <td>&nbsp;Level&nbsp;</td>
    <td>&nbsp;Weapon&nbsp;</td>
    <td>&nbsp;Gold / In bank&nbsp;</td>
    <td>&nbsp;Onlinetime&nbsp;</td>
  </tr>
<?php
$query = mysql_query("SELECT charname, charclass, difficulty, level, weapon, gold, bank, onlinetime FROM dk_users ORDER BY level DESC, difficulty DESC, onlinetime DESC limit 50");
$i=0;
while($row = mysql_fetch_array($query)) {
  print '<tr bgcolor="' . ($i%2)==0 ? '#d3d3d3' : '#f3f3f3' . '">';
  print '<td>'.$row['charname'].'</td>';
  print '<td>'.$row['charclass'].'</td>';
  print '<td>'.$row['difficulty'].'</td>';
  print '<td>'.$row['level'].'</td>';
  print '<td>'.$row['weapon'].'</td>';
  print '<td>'.$row['gold'].'</td>';
  print '<td>'.$row['bank'].'</td>';
  print '<td>'.$row['onlinetime'].'</td>';
  print "<tr>\n";
  $++;
}
?>
</table>

nope:)

Parse error: parse error, unexpected T_INC, expecting T_VARIABLE or '$' in line 25

nederst;
$++;
skal være:
$i++;

:)

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in line 16



<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
  <tr>
    <td>&nbsp;Charname&nbsp;</td>
    <td>&nbsp;Charclass&nbsp;</td>
    <td>&nbsp;Difficulty&nbsp;</td>
    <td>&nbsp;Level&nbsp;</td>
    <td>&nbsp;Weapon&nbsp;</td>
    <td>&nbsp;Gold / In bank&nbsp;</td>
    <td>&nbsp;Onlinetime&nbsp;</td>
  </tr>
<?php
$connect = mysql_connect("localhost","xxxxxx","xxxxxx");
$db = mysql_select_db("xxxxxxxxxx");
$query = mysql_query("SELECT charname, charclass, difficulty, level, weapon, gold, bank, onlinetime FROM dk_users ORDER BY level DESC, difficulty DESC, onlinetime DESC limit 50");
$i=0;
while($row = mysql_fetch_array($query)) {
  print '<tr bgcolor="' . ($i%2)==0 ? '#d3d3d3' : '#f3f3f3' . '">';
  print '<td>'.$row['charname'].'</td>';
  print '<td>'.$row['charclass'].'</td>';
  print '<td>'.$row['difficulty'].'</td>';
  print '<td>'.$row['level'].'</td>';
  print '<td>'.$row['weapon'].'</td>';
  print '<td>'.$row['gold'].'</td>';
  print '<td>'.$row['bank'].'</td>';
  print '<td>'.$row['onlinetime'].'</td>';
  print "<tr>\n";
$i++;

}
?>
</table>

erstat:

$query = mysql_query("SELECT charname, charclass, difficulty, level, weapon, gold, bank, onlinetime FROM dk_users ORDER BY level DESC, difficulty DESC, onlinetime DESC limit 50");

med:
$query = mysql_query("SELECT charname, charclass, difficulty, level, weapon, gold, bank, onlinetime FROM dk_users ORDER BY level DESC, difficulty DESC, onlinetime DESC limit 50") or die(mysql_error());

Er charname, charclass, difficulty, level, weapon, gold, bank, onlinetime ikke kolonner i tabellen dk_users ?

jo ...prøver lige 'erstat'

nu får jeg ingen fejl, men ---> http://www.musicman.dk/temp-rpg/22.php :)

oopsa :-)

erstat
print '<tr bgcolor="' . ($i%2)==0 ? '#d3d3d3' :  . '">';

med:
if( ($i%2)==0 )
  print '<tr bgcolor="#f3f3f3">';
else
  print '<tr bgcolor="#d3d3d3">';

Yessir... så lige den sidste, de penge der er i banken står i onlinetime

erstat:
  print '<td>'.$row['gold'].'</td>';
  print '<td>'.$row['bank'].'</td>';
med:
  print '<td>'.$row['gold'].' / ' . $row['bank'] . '</td>';

http://www.musicman.dk/tek/images/smiles/worship.gif

husk at smid et svar...

haha :)

Tak .: