$result = mysql_query("SELECT * FROM `db`");
while($row = mysql_fetch_array($result)) {
echo $row['id'] . " " . $row['one'];
echo "<br />";
$arr0 = array();
$arr = array(
$row['one'],
$row['two'],
$row['three']
);
array_push($arr0, $jundui); //把后面的一维数组,增加到前面的数组里面
}print_r($arr0);可是无论怎样,print_r都只是最后一条数据啊???有高手有没有什么好的方法啊 如何把从数据库取出的数据存入二维数组?
while($row = mysql_fetch_array($result)) {
echo $row['id'] . " " . $row['one'];
echo "<br />";
$arr0 = array();
$arr = array(
$row['one'],
$row['two'],
$row['three']
);
array_push($arr0, $jundui); //把后面的一维数组,增加到前面的数组里面
}print_r($arr0);可是无论怎样,print_r都只是最后一条数据啊???有高手有没有什么好的方法啊 如何把从数据库取出的数据存入二维数组?
while($row = mysql_fetch_array($result)) {
echo $row['id'] . " " . $row['one'];
echo " <br />";
$arr = array(
$row['one'],
$row['two'],
$row['three']
);
array_push($arr0, $jundui); //把后面的一维数组,增加到前面的数组里面
}
$result = mysql_query("SELECT * FROM `db`");
while($row = mysql_fetch_array($result)) {
echo $row['id'] . " " . $row['one'];
echo " <br />";
$arr[] = array(
$row['one'],
$row['two'],
$row['three']
);
}
print_r($arr);
while($row = mysql_fetch_array($result)) {
echo $row['id'] . " " . $row['one'];
echo " <br />";
$arr = array(
$row['one'],
$row['two'],
$row['three']
);
array_push($arr0, $arr); //把后面的一维数组,增加到前面的数组里面
}
$rowno = 0;
$rowno = MySQL_num_rows($res);
if($rowno>0)
{
for($row=0;$row<$rowno;$row++ )
{
$rows[$row]=MySQL_fetch_array($res);
//本来为MySQL_fetch_row,但是不能以数组的方式来提取,只能用索引
//这样可以用索引和名称,更为方便
}
return $rows;
}
$conn =& ADONewConnection('mysql');
$conn->PConnect('localhost','jnkc','password','csdn');print_r($conn->GetAll("SELECT * FROM tb"));