php mysql error beginner
Part I - Solved.
Hi, I'm trying to print some values on the screen from a table but I having a problem, I don't know much about string, vector and array but I think that my problem is related to them.
I'm getting this on the screen
Fatal error: Cannot use [] for reading ...
My code
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql) or trigger_error(mysql_error().$sql);
while($row = mysql_fetch_array($result)){
$DATA = $row[]; } //line with probelm
mysql_close();
//html part
<table>
<? foreach($DATA as $row): ?>
<tr>
<td&g开发者_如何转开发t;<?=$row['id']?></td>
//more stuff
</tr>
<? endforeach ?>
</table>
What I'm trying to do is print somevalues form a database. But I'm getting this error.
I'm sorry for any mistake in English, and thanks in advance for any help.
Part II - Edited
Ok, seems like the mysql part is working, i used this before the html.
mysql_close();
echo "".$DATA[0][0];
To see if it's working and it printed the right value. But my html part is not printing right.
<html>
<body>
<h1>Lista de usuários</h1>
<table>
<? foreach($DATA as $row): ?>
<tr>
<td><?=$row['id']?></td>
<td><?=$row['nome']?></td>
//more stuff like this
</tr>
<? endforeach ?>
</table>
</body>
</html>
Can you help me? I'm sorry for any mistake in English, and thanks in advance for any help.
Use:
$DATA = array();
...
while($row = mysql_fetch_array($result)) {
$DATA[] = $row;
}
The [] operator is used to append a row, which is what we want to do to $DATA. That means that it will never show up on the right side of an assignment statement.
For part 2, as a commenter suggested, remove <? and <?= and use <?php and <?php echo instead. If that doesn't fix the problem, please post the error / unexpected answer you are receiving.
加载中,请稍侯......
精彩评论