array -> query

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kirke
    #1

    array -> query

    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($data y);


    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!!!!

    Tags: None
    • Colin Fine
      #2
      Re: array -> query

      kirke wrote:
      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($data y);
      >
      >
      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

        Comment

        • kirke
          #3
          Re: array -> query

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


          Colin Fine wrote:
          kirke wrote:
          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($data y);


          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

            Comment

            Previous template Next
            Working...