[PHP] Re: MySQL Workbench coming for Linux
Ross McKay wrote: Posting this here, because a few people responded when I mentioned not having a Linux-native data modelling tool. Apparently, MySQL Workbench should be alpha-ready by end of the month... I've been waiting for this. I'm getting tired of DBDesigner4's bugs and all. -- Dax Solomon Umaming http://blog.knightlust.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] database design tool
On Feb 12, 2008 7:46 PM, Shawn McKenzie [EMAIL PROTECTED] wrote: Can anyone recommend a preferably visual DB design tool? I normally use mysql, but one that covered several types wood be cool. I'm on Linux, so the new mysql workbench is a dud. I used it in an alpha or prior version and it looked promising but crashed frequently. They say a Linux version in 2008, but I'm not holding my breath. Try DBDesigner4[1], MySQL based their workbench from DBDesigner. However, it won't allow you to connect to MySQL5 and sync your changes, but hey, you're looking for a graphical designer - and this tool is great for designing your DBs. You can install from source and tweak it a bit or you can install the win32 binary and let it run via wine (which works really well). [1] fabforce.net/dbdesigner4/ -- Dax Solomon Umaming http://knightlust.com/ GPG: 0x715C3547 signature.asc Description: This is a digitally signed message part.
[PHP] Sum of results
Hi;
I've tried Googling this out but failed to search for an answer to this, so
I'm posting to this list. I'd like to know if there's a way to get the sum
this results:
// Results
Individual Daily Consumption
//AccountNo : Consumption
4146121002: 1.42
4146111002: 0.29
4146113002: 1.38
4146110002: 0.33
4146112002: 0.00
4146118002: 9.96
== MORE ==
// Code that generated the results
while ($row6 = mysql_fetch_assoc($queryconsumerresults)) {
// Show Consumer AccountNo and their Consumption
echo $row6['AccountNo'] . : . sprintf(%1.2f, $row6['Reading']
+
$row6['KwHrAdjustment']) - ($row6['Reading1'] + $row6['KwHrAdjustment1'])) /
$noofdays) * $row6['Multiplier'])) . br /;
}
I've tried getting the sum() from the MySQL table, but Multiplier is either at
1 or 2 or 2.5 and the only way I can get an accurate total consumption is
getting the sum from the results.
Is there a way I can place this code on an array? I've tried using
$indcons = array( sprintf(%1.2f, $row6['Reading'] + $row6
['KwHrAdjustment']) - ($row6['Reading1'] + $row6['KwHrAdjustment1'])) /
$noofdays) * $row6['Multiplier']))) but I've obviously failed.
--
Dax Solomon Umaming
http://knightlust.com/
GPG: 0x715C3547
signature.asc
Description: This is a digitally signed message part.
