Results 1 to 2 of 2

Thread: If condition on SQL

  1. #1
    Join Date
    Oct 2007

    If condition on SQL


    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
    PHP Code:
    $sql ". . . SUM(IF(`cm`='EURO', `line_net` * $multiplier, `line_net`)) . . ."
    See http://dev.mysql.com/doc/refman/5.1/...ml#function_if
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

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