Untitled

SQL/PHP calculate percent of yes/no votes
$query  = "SELECT ((yes / (yes+no)) * 100) as yesPercent, ((no / (yes+no)) * 100) as noPercent FROM table WHERE id=1";
$result = mysql_query($query);

echo $result;

$result = mysql_query($query);

id - item - yes   - no
1  - name - 400  - 600

SELECT ((yes / (yes+no)) * 100) as yesPercent, ((no / (yes+no)) * 100) as noPercent FROM table WHERE id=1