ODBC array results

[mr_zog]

OK,

Let me see if I can explain this as best as
I can. I am using a script which dynamically generates graphs. The info needed for the plot on the y axis are in array $ydata.

$ydata=array();

In order to get the info into $ydata I need to select data from a database and return it. I then use an array to get the information.

while(odbc_fetch_into($result,&$fields))
{
$usage=$fields[0];
}

What I am trying to figure out, and it is probably my syntax, is how to generate a result so that

$ydata=array($usage);

What this will return is the first value.

It will plot as well if I fill in vaules in $ydate for example

$ydata=array(12,4,5,6,21,4,2,6);

That is another of my dilemas is they need to be comma delimited.

I am sure it is my WHILE Loop and since I am a relative newbie to PHP and have to work with the ODBC driver collection I was looking for some help.

Thanks

[monexx]

Pretty simple, try the following:

$count = 0;
while(odbc_fetch_into($result,&$fields))
{
$ydata[$count]=$fields[0];
$count++;
}

Maybe there is a better way, but since i never use ODBC, i don't know. But this will work for sure.

And to extract the array into a string with each result separated by commas, use the following:

$new_string = implode(",",$ydata);

Hope that helps

S. Breton

[mr_zog]

That got the job done

Thanks