Connecting Tech Pros Worldwide Help | Site Map

array -> query

kirke
Guest
 
Posts: n/a
#1: Oct 18 '06
I have a code with following data format


$datay = array(
34,42,27,45,
55,25,14,59,
38,49,32,64);
$p1 = new StockPlot($datay);


However, I want to change it to query format.
That is,

$sql_A = 'SELECT dtDateTime FROM ~~ WHERE ~~~ ';
$sql_B = 'SELECT dtDateTime FROM ~~ WHERE ~~~ ';
$sql_C = 'SELECT dtDateTime FROM ~~ WHERE ~~~ ';

After executing $sql_A,B,C Query, I can get an data A,B,C ,
respectively.

A = 34, 42, 27, 45
B = 55, 25, 14, 59
C = 38, 49, 32, 64

In that case, How can I write change the code? Moreover, actually
length of A,B,C are all different.
Is it possible? Or should I change the StockPlot function?

Thank you!!!!

Colin Fine
Guest
 
Posts: n/a
#2: Oct 21 '06

re: array -> query


kirke wrote:
Quote:
I have a code with following data format
>
>
$datay = array(
34,42,27,45,
55,25,14,59,
38,49,32,64);
$p1 = new StockPlot($datay);
>
>
However, I want to change it to query format.
That is,
>
$sql_A = 'SELECT dtDateTime FROM ~~ WHERE ~~~ ';
$sql_B = 'SELECT dtDateTime FROM ~~ WHERE ~~~ ';
$sql_C = 'SELECT dtDateTime FROM ~~ WHERE ~~~ ';
>
After executing $sql_A,B,C Query, I can get an data A,B,C ,
respectively.
>
A = 34, 42, 27, 45
B = 55, 25, 14, 59
C = 38, 49, 32, 64
>
In that case, How can I write change the code? Moreover, actually
length of A,B,C are all different.
Is it possible? Or should I change the StockPlot function?
>
Thank you!!!!
>
Your question does not make very much sense to me, but I think you mean
that you have some implicit structure in your array, that you should
make explicit.

Something like

$datay = array(
array(34,42,26,45),
array(55,25,14,59),
array(38,49,32,64)
);

But I may have misunderstood what you wanted.

Colin

kirke
Guest
 
Posts: n/a
#3: Oct 23 '06

re: array -> query


I know my question is toooooo nonsense. Thx though :->


Colin Fine wrote:
Quote:
kirke wrote:
Quote:
I have a code with following data format


$datay = array(
34,42,27,45,
55,25,14,59,
38,49,32,64);
$p1 = new StockPlot($datay);


However, I want to change it to query format.
That is,

$sql_A = 'SELECT dtDateTime FROM ~~ WHERE ~~~ ';
$sql_B = 'SELECT dtDateTime FROM ~~ WHERE ~~~ ';
$sql_C = 'SELECT dtDateTime FROM ~~ WHERE ~~~ ';

After executing $sql_A,B,C Query, I can get an data A,B,C ,
respectively.

A = 34, 42, 27, 45
B = 55, 25, 14, 59
C = 38, 49, 32, 64

In that case, How can I write change the code? Moreover, actually
length of A,B,C are all different.
Is it possible? Or should I change the StockPlot function?

Thank you!!!!
>
Your question does not make very much sense to me, but I think you mean
that you have some implicit structure in your array, that you should
make explicit.
>
Something like
>
$datay = array(
array(34,42,26,45),
array(55,25,14,59),
array(38,49,32,64)
);
>
But I may have misunderstood what you wanted.
>
Colin
Closed Thread


Similar PHP bytes