sql data to array php... urgent 10 points.?

Question

i want to put my data in a array php.... so that i can use it to in my graph.. for example:
my data in mysql is
equipment<------colum name
m600
ced11
fat25
---------------
my array will be

$a= m600;
$B = ced11;
$c = fat25;
just an example that i want in array. i know it is nnot working.. i want a code answer not explanation. please help me. urgent..

Answer 1

$count = 0;

$array = array();

$mysql_query = $mysqli->query("SELECT equipment FROM your_table");

if($mysql_query->num_rows) {

while($mysql_row = $mysql_query->fetch_assoc()) {

$aray[$count] = $mysql_row['equipment'];

$count++;

}

}

Answer 2

Hi,

Please use below code for your requirement.

$typeArray = array();

$query = "select equipment from table";

$result = mysql_query($query);



if ($result) {

$i = 0;

while ($record = mysql_fetch_array($results))

{

$typeArray[$i] = $record['equipment'];

$i = $i+1;

}

}



$typeArray will contain your data

Answer 3

$information[0]="m600"; $information[a million]="ced11"; $information[2]="fat25"; now to echo an merchandise in this array do right here: echo $information[0]; U could additionally make arrays like this: $information=array("m600","ced11","fat25"); to echo this u ought to apply the comparable approach as pronounced above. be conscious: in case you utilize mysql_fetch_array the products interior the database will automaticly bypass in an array! occasion: $row = mysql_fetch_array(mysql_query(choose * FROM occasion)); echo $row[0];