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 - perl


      I 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

    Your reply:

    Name: EMail: WWW:
    Subject:
    Text:
    Timezone:

    Post a new message


 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 design


      ive just gone through the tutorial , but i dont know how i can incorporate the database into a website ive designed.
     Post a reply

    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 design


      Just 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

      <do action=all db=databasename>

      at the position you like. Then link from your web page to the given baseportal URL of the page you've created... Thats it ;-)

     Post a reply
     
 Messages from 2850 to 3000: To the input form 
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >>


Back to the homepage

© baseportal.com. All rights reserved. Terms of use



baseportal.com