Get a percentage between 2 mysql fields

Discussion in 'MySQL' started by pnaidoo, Mar 8, 2013.

0
  1. #1
    Hi everyone

    Can someone help me with the correct php script to display the percentage between 2 mysql database fields?

    My database has two fields: Provider and Completed

    The script should check the number of rows for the provider and show the percentage where the Completed field is 0.

    Thanks for your help
     
    pnaidoo, Mar 8, 2013 IP
  2. cahya77

    cahya77 Member

    Messages:
    80
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #2
    select count(Provider), Provider*0.01 from DB where Completed = 0
     
    cahya77, Mar 8, 2013 IP