www.webdeveloper.com
Results 1 to 2 of 2

Thread: If condition on SQL

  1. #1
    Join Date
    Oct 2007
    Posts
    113

    If condition on SQL

    Hi

    I have the following sql statement

    "SELECT fat_id, crn, sum(adet) as ad, sum(line_net) as ln, sum(line_vat) as lv, sum(line_grand) as lg FROM inv_lines where fat_id='$row->id' group by fat_id"
    So, I would like mysql to check each row as summing and if the crn field is "EURO" then the respective field value for line_net should be multiplied by a given constant value

    Is it possible

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,604
    PHP Code:
    $sql ". . . SUM(IF(`cm`='EURO', `line_net` * $multiplier, `line_net`)) . . ."
    See http://dev.mysql.com/doc/refman/5.1/...ml#function_if
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles