php - I want to make a sum from 5 tables that have one column named "UP" -

-

i have 5 tables (bepd , tirpd , elpd , frpd , kopd) same column named "up" , , want make sum of tables , show in php code . can me ?

select  sum(sumup)    (         select  sum(up) sumup            table1          union         select  sum(up)            table2         union         select  sum(up)            table3         union         ...         ) subqueryalias

Comments

Post a Comment

Popular posts from this blog

php - Array to string conversion smarty template -

-
hello have array string conversion erro code: index.php: code: $hoarr = array(1,2,3); foreach ($hoarr $hid) { $mysqli = mysqli_connect("localhost", "root", "", "zabbixtest"); if (!$mysqli) { die("connection failed: " . mysqli_connect_error()); } $sql = "select errors_from hosts hostid = '$hid'"; $re = mysqli_query($mysqli, $sql); while ($row = mysqli_fetch_assoc($re)) { $query_times[] = $row['errors_from']; } mysqli_free_result($re); mysqli_close($mysqli); } $smarty->assign('query_times',$query_times); and index.tpl: code: <p>{$query_times}</p> i have no idea whats wrong it.. you try assign array $smarty->assign can assign string. use instead: $query_string = implode ( "," , $query_times ); $smarty->assign('query_times',$query_string);
Read more

Winapi c++: DialogBox hangs when breaking a loop -

-
i've created s simple w32 application cicle through 2 applications(hard coded window classes atm). when call start button (idc_start) works fine, when change focus hwnd application hangs cannot closed. need simple , clean method stop loop, start when calling idc_start. apreciated! #include <stdio.h> #include <stdlib.h> #include <conio.h> #include <windows.h> #include <resource.h> #include <iostream> using namespace std; bool callback dlgproc(hwnd hwnd, uint message, wparam wparam, lparam lparam) { hwnd hwnd1,hwnd2; hwnd1 = findwindow("notepad++",0); hwnd2 = findwindow("notepad",0); bool bdone; switch(message) { case wm_initdialog: // set dialog box, , initialise default values { setdlgitemint(hwnd, idc_number, 5, false); hicon hicon, hiconsm; hicon = (hicon)loadimage(null, "e32.ico", image_icon, 32, 32, lr_loadfromfile); if(hicon) se...
Read more

vb.net - Font adding using PDFsharp -

-
i using pdfsharp add text pdf. when use below code add following text these fonts facing problem. after pdf created using pdfsharp , when opened in adobe reader getting message "cannot find or create font 'windings'. characters may not display or print correctly." opens the source pdf trying modify has fonts helvetica , windings(embedded) this part of code adds text pdf dim font xfont = new xfont("verdana", 20, xfontstyle.regular) gfx.drawstring("hello, world!", font, xbrushes.black, new xrect(0, 0, page.width, page.height), xstringformats.center) font = new xfont("wingdings", 20, xfontstyle.regular) gfx.drawstring("llll", font, xbrushes.black, new xrect(25, 15, page.width, page.height), xstringformats.center) font = new xfont("helvetica", 20, xfontstyle.regular) gfx.drawstring("abcd", font, xbrushes.black, new xrect(50, 25, page.width, page.height), xstringformats.center) after using code text ge...
Read more