array

[Jenling]

Dear expert,

I want to use array to do the system. I want to get the query from database and use array to display the data. How can I do that? My code is as below:

<?
$sql="select MRname from meetingroom";
$resu = mysql_query($sql, $connect) or die('Error when running command<br>'.$sql);
$num=@mysql_num_rows($resu);
while($row_Recordset=mysql_fetch_array($resu, MYSQL_BOTH)){
$m=array($row_Recordset[MRname]);
}

 

$meeting = array($m);

[The Little Guy]

Some thing like this could work:

 

<?php
$myArray
$sql="select MRname from meetingroom";
$resu = mysql_query($sql, $connect) or die('Error when running command<br>'.$sql);
$num=@mysql_num_rows($resu);
while($row_Recordset=mysql_fetch_array($resu, MYSQL_BOTH)){
    $myArray[] = $row_Recordset['Column_Name_Here'];
}
?>

[Jenling]

It still cant work...I wonder why. can u give me more idea? I want to display the particular column with array..

[Barand]

try

<?php

$sql="select MRname from meetingroom";
$resu = mysql_query($sql, $connect) or die('Error when running command<br>'.$sql);

$m = array();                                                        // create empty array
while($row_Recordset=mysql_fetch_assoc($resu)){
    $m[] = $row_Recordset['MRname'];                                 // add names to array
}

// output the array
foreach ($m as $room)
{
    echo $room, '<br />';
}

?>