mysql to array

[Gazz1982]

firstly i am quite rusty at php/sql so sorry in advance.

 

I have a php script to produce graphs with the GD library, alls working well, but I want to modify it so the data comes from my database.

 

so I connect to the database in the usuall way but the script uses an array

 

$values = array("23","32","35","57","12","3","36","54","32","15","43","24","30");

 

so I need mysql to out put in the same format

 

This is what I have so far, it prints out the data with some formating, thank you for any help you can offer

 

Gary

 

// Make a MySQL Connection

$query = "SELECT Question, COUNT(Answer) FROM question1 GROUP BY Question"; 

$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){

echo "There are ". $row['COUNT(Answer)'] ." ". $row['Question'] ." items.";
}

[rondog]

you would simply use array_push to store the value

 

<?php
// Make a MySQL Connection
$query = "SELECT Question, COUNT(Answer) FROM question1 GROUP BY Question";
$result = mysql_query($query) or die(mysql_error());
$values = array();

// Print out result
while($row = mysql_fetch_array($result)){

   echo "There are ". $row['COUNT(Answer)'] ." ". $row['Question'] ." items.";
   array_push($values,$row['COUNT(Answer)']);
}
// $values is now an array of data so continue with your script
?>

[Gazz1982]

Hi,

sorry but that doesnt seem to solve my problem... I will rephrase:

 

I have $values=array("1","3","7")

 

I need to change it so it is something like this:

$values=array(MySQL_result)

 

Here is the simplified code

from above

// Make a MySQL Connection

$query = "SELECT Question, COUNT(Answer) FROM question1 GROUP BY Question";
$result = mysql_query($query) or die(mysql_error());
$values = array();

// result
while($row = mysql_fetch_array($result))
{   
array_push($values,$row['COUNT(Answer)']);
}

[rondog]

Not sure I am understanding. So your script requires $values to be an array of numbers, right?

 

So I made an empty array called $values.

 

The while loop will loop through every record found that matches your query. I array_push each record, assuming the 'Answer' column is a number, to the $values array. What is the problem?

[Gazz1982]

oh it works... I mmust have done something wrong, thank you