Cannot use object of type stdClass as array
<div id="account_overzicht">
<table>
<tr>
<th>
User id:
</th>
<th>
Gebruikersnaam:
</th>
<th>
Rechten:
</th>
</tr>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
<?
$sql = "SELECT name,active FROM `".$db_tbl."` ORDER BY name ASC";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
$activate= $row['activate'];
$id = $row['id'];
$name = $row['name'];
$rank = $row['rank'];
if($active == 0) {
echo "<tr>";
echo "<td>".$id."</td>";
echo "<td><font color=\"red\">".$name."</font></td>";
echo "<td>".$rank."</td>";
echo "</tr>";
}
else
{
echo "<tr>";
echo "<td>".$id."</td>";
echo "<td>".$name."</td>";
echo "<td>".$rank."</td>";
echo "</tr>";
}
}
?>
$sql = "SELECT name,active FROM `".$db_tbl."` ORDER BY name ASC";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
$activate= $row['activate'];
$id = $row['id'];
$name = $row['name'];
$rank = $row['rank'];
if($active == 0) {
echo "<tr>";
echo "<td>".$id."</td>";
echo "<td><font color=\"red\">".$name."</font></td>";
echo "<td>".$rank."</td>";
echo "</tr>";
}
else
{
echo "<tr>";
echo "<td>".$id."</td>";
echo "<td>".$name."</td>";
echo "<td>".$rank."</td>";
echo "</tr>";
}
}
?>
</table>
<small>Gebruikers die rood in de lijst staan, zijn momenteel gedeactiveerd.</</small>
</div>
geen error meer zie alleen id en rechten niet.
mvg ralph
Gewijzigd op 19/04/2012 11:14:39 door Ralph van der Tang
Code (php)
1
while($row = mysql_fetch_object($query)) {
eens
Code (php)
1
while($row = mysql_fetch_array($query)) {
hoe kan ik dat oplossen
script geupdate
groet ralph
Toevoeging op 19/04/2012 11:17:34:
dank je hij doet t