StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCreate a monthly records tables from different scripts
text
Body
copied!<p>I would like to ask for some idea support how to achieve to create a table from 5 different MYSQL scripts in PHP. The result of each of them is SUM of data group by months. I do not want to vast time much to scripts because all of them are ok when activates alone. </p> <p>I will put theoretical query in order to not make my message very long.</p> <pre><code><?php $qry = "SUM(CASH) group by MONTH DESC"; $result=mysql_query($qry) or die(mysql_error()); $qry2 = "SUM(DEBT) group by MONTH DESC"; $result=mysql_query($qry2) or die(mysql_error()); $qry3 = "SUM(DEBTPAID) group by MONTH DESC"; $result=mysql_query($qry3) or die(mysql_error()); $qry4 = "SUM(INVOICE) group by MONTH DESC"; $result=mysql_query($qry4) or die(mysql_error()); $qry5 = "SUM(NVOICEPAYOFF) group by MONTH DESC"; $result=mysql_query($qry5) or die(mysql_error()); ?> </code></pre> <p>I want to achieve a TABLE like this:</p> <pre><code><table> <tr> <td>CASH</td> <td>DEBT</td> <td>DEBTPAID</td> <td>INVOICE</td> <td>INVOICEPAYOFF</td> </tr> <? echo '<tr>'; echo '<td><label>'. $row['CASH'] .'</label></td>'; echo '<td><label>'. $row2['DEBT'] .'</label></td>'; echo '<td><label>'. $row3['DEBTPAID'] .'</label></td>'; echo '<td><label>'. $row4['INVOICE'] .'</label></td>'; echo '<td><label>'. $row5['INVOICEPAYOFF'] .'</label></td>'; echo '</tr>'; ?> </table> </code></pre> <p>I will appreciete your every idea, solutions or recommendation. Thank you in advance! </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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