Autor | Zpráva | ||
---|---|---|---|
Ston3 Profil * |
#1 · Zasláno: 17. 3. 2015, 10:08:16
Zdravim, vypisuju si ciselne polozky z databaze a potrebuju secist vsechny polozky pole promenne $zaplneni, ale nedari se, mam zapsane takto. PCT_UTILIZED, STATUS, ACCESS, PCT_RECLAIM, ERROR_STATE, TIMES_MOUNTED FROM volumes WHERE DATE='".$prom_vybranedatum."' "; $retval = mysql_query( $sql, $conn ); while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) { $zaplneni = ($row['EST_CAPACITY_MB'] / "100")*$row['PCT_UTILIZED']; $zaplnenombrow = array_sum($zaplneni); $zaplnenombrowshow = number_format($zaplnenombrow, 2, ',', ' '); echo (" <td><strong>" . $zaplnenombrowshow ."</strong></td> "); } |
||
Keeehi Profil |
#2 · Zasláno: 17. 3. 2015, 10:31:38
$sql = "SELECT SUM((EST_CAPACITY_MB/100)*PCT_UTILIZED) FROM volumes WHERE DATE='".$prom_vybranedatum."' "; $retval = mysql_query( $sql, $conn ); echo " <td><strong>" . number_format(mysql_result($retval,0), 2, ',', ' ')."</strong></td> "; |
||
Časová prodleva: 11 let
|
0