baseportal | ||
Start | ||
baseportal message board | |
Welcome to the baseportal message board... Please read the FAQ.
|
Selected message: | To the list |
Message from TheOneRing on 1/3 2004, 05:53 +00:00 EMail: theonering@thegateroom.com WWW: geocities.com/theonering_stargate Really need help here - perlI need to sum the total of a field IF it meets certain criteria. My database looks a bit like this: Title (field) Chapter (field) Size (field) My Life .......... 1 ................ 5 My Life .......... 2 ................10 My Life .......... 3 ................ 8 The Revenge.....1 ..............30 The Suspect.....1 ..............10 The Suspect.....2 ..............20 I need to sum the field "Size" IF the field "Title" is the same story title. But, obviously I don't want to query the actual field value...too many entries. So I have to use variable names like $Title and $Size. In the example above, my sums should be: For My Life Sum=23 The Revenge Sum=30 The Suspect Sum=30 It sounds like it should be easy enough but I've been playing with it for weeks and can't get what I need. Any help would be appreciated. Thanks, TheOneRing |
|
All messages from this thread: | To the list |
Message from david lani on 1/4 2004, 17:02 +00:00 EMail: garygooner@lycos.com how do i incorporate a database into my own website designive just gone through the tutorial , but i dont know how i can incorporate the database into a website ive designed. |
Message from Christoph Bergmann on 1/6 2004, 04:05 +01:00 EMail: info@baseportal.com Re: how do i incorporate a database into my own website designJust copy the HTML code of your web page (with the desired design) into a baseportal page (Create new page -> Do not use a template -> HTML code) and then insert
at the position you like. Then link from your web page to the given baseportal URL of the page you've created... Thats it ;-) |
Messages from 2850 to 3000: | To the input form |
> how do i incorporate a database into my own website design from david lani on 1/4 2004, 17:02 +00:00 Re: how do i incorporate a database into my own website design from Christoph Bergmann on 1/6 2004, 04:05 +01:00 |
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >> |
© baseportal.com. All rights reserved. Terms of use |