Databases
StackOverflow2013
Postsdbo
PORetrieving specific data from sql query
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORetrieving specific data from sql query
    primarykey
    data
    text
    <p>Let's say I have the following query, wich gives me the amount of coupons downloaded and redeemed, grouped by date: [EDIT](I can't modify this query)[/EDIT]</p> <pre><code>$sql = "SELECT DATE(datetime) , SUM(CASE WHEN datetime!='' THEN 1 ELSE 0 END) As downloaded , SUM(CASE WHEN used = 1 AND DATE(datetime) != '' THEN 1 ELSE 0 END) AS redeemed FROM Promotion_Redeem WHERE datetime BETWEEN '2013-10-01' AND '2013-10-04' GROUP BY DATE(datetime)"; </code></pre> <p><strong>How can I get the sum of downloaded and the sum of redeemed?</strong> this should be within $sql, somewhere... below is the result for this query:</p> <pre><code>row number 1 array (size=3) 0 =&gt; string '2013-10-01' (length=10) 1 =&gt; string '126' (length=3) 2 =&gt; string '11' (length=2) row number 2 array (size=3) 0 =&gt; string '2013-10-02' (length=10) 1 =&gt; string '106' (length=3) 2 =&gt; string '5' (length=1) row number 3 array (size=3) 0 =&gt; string '2013-10-03' (length=10) 1 =&gt; string '228' (length=3) 2 =&gt; string '12' (length=2) row number 4 array (size=3) 0 =&gt; string '2013-10-04' (length=10) 1 =&gt; string '149' (length=3) 2 =&gt; string '9' (length=1) </code></pre> <p>[EDIT]bove you can see I get 4 rows, each one whith an array... I want, for instance, the sum of the third field from each of these arrays... In my example, this would equals to 37 (that means, 37 coupons redeemed)[/EDIT] I got this data structure after using this:</p> <pre><code>while ($row = mysql_fetch_row($result)) { echo "row number ".++$i; var_dump($row); } </code></pre> <p>Thanks in advance</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLucas Jota
    1. USLucas Jota
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThere is **no more support** for `mysql_*` functions, they are [**officially deprecated**](https://wiki.php.net/rfc/mysql_deprecation), **no longer maintained** and will be [**removed**](http://php.net/manual/en/function.mysql-connect.php#warning) in the future. You should update your code with [PDO](http://php.net/pdo) or [MySQLi](http://php.net/msqli) to ensure the functionality of your project in the future.
      singulars
      1. PORetrieving specific data from sql query
      1. USNeal
    2. CONot sure what you need... Sum of all received data? Get you your results if you delete `GROUP BY` section?
      singulars
      1. PORetrieving specific data from sql query
      1. USvp_arth
    3. CO@vp_arth in my question you can see I get 4 rows, each one whith an array... I want, for instance, the sum of the third field from each of these arrays... In my example, this would equals to 37 (that means, 37 coupons redeemed)
      singulars
      1. PORetrieving specific data from sql query
      1. USLucas Jota
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload