Professional Web Applications Themes

Feeling a bit brain dead, please help in maths: averages - PHP Development

Hey, Been working a bit too much i guess so am feeling braindead... I have a couple of records in the database, i am doing a: "select age,salTotal from blah where section=3" this is getting me a list of records, how do i calculate the average age and salary total (salTotal) to display in my php page? Cheers, -Ryan A We will slaughter you all! - The Iraqi (Dis)information ministers site [url]http://MrSahaf.com[/url]...

  1. #1

    Default Feeling a bit brain dead, please help in maths: averages

    Hey,
    Been working a bit too much i guess so am feeling braindead...

    I have a couple of records in the database, i am doing a: "select
    age,salTotal from blah where section=3"
    this is getting me a list of records, how do i calculate the average age and
    salary total (salTotal) to display in my php page?

    Cheers,
    -Ryan A



    We will slaughter you all! - The Iraqi (Dis)information ministers site
    [url]http://MrSahaf.com[/url]
    Ryan A Guest

  2. #2

    Default Re: [PHP] Feeling a bit brain dead, please help in maths: averages

    * Thus wrote Craig Lonsbury (craigtopdraw.com):
    > off the top of my head:
    >
    > SELECT AVG(age), SUM(salTotal)
    > FROM blah
    > WHERE section = 3
    >
    > i'm not sure if you can use the 2 functions in the same query,
    > you might have to break it into 2 queries.
    Yes you can. And if you have other fields in the select you add a
    group by to the sql statement

    SELECT AVG(age), SUM(salTotal), otherfield
    FROM blah
    WHERE section = 3
    group by otherfield

    Assuming this is mysql:
    [url]http://www.mysql.com/doc/en/GROUP-BY-Functions.html[/url]


    Curt
    --
    "I used to think I was indecisive, but now I'm not so sure."
    Curt Zirzow Guest

Similar Threads

  1. Averages
    By ericMorcombe in forum Dreamweaver AppDev
    Replies: 4
    Last Post: March 23rd, 10:26 AM
  2. lingo averages..HELP!
    By jen in forum Macromedia Director Lingo
    Replies: 0
    Last Post: November 11th, 11:52 AM
  3. Replies: 1
    Last Post: September 17th, 09:41 PM
  4. Is this IPC scheme brain-dead?
    By Richard in forum UNIX Programming
    Replies: 4
    Last Post: July 29th, 02:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139