choosing certain info from a db

[CHeeSeBLiND]

ok im really dumb how do you select a certain value from a certain record in a database?

what im trying to do is make a poll script and i was wondering how i can add up the total amount of votes so i can figure out the percentages

in the table there are only 3 fields ( ID, value, votes ) do you think that is enough or will i need to add more?

thx alot

[Richi]

$query = mysql_query("Select * from Table_Name order by votes");
list($ID,$value, $votes ) = mysql_fetch_row($query);

echo "$ID ... $VALUE ... $votes"; 

[lynlimz]

Hi,
I don't know how you store your votes..but i'll assume 'votes' is the number of vote for each ID

$total_vote = 0;
$query = mysql_query("SELECT votes from tablename");
while (list($votes) = mysql_fetch_row($query)) {
    $total_vote += $votes;
}

$query = mysql_query("SELECT * from tablename ORDER BY votes");
while ($row=mysql_fetch_row($query)) {
    extract($row);
    $per_vote = $votes/$total_vote;
    echo "$ID has a Percentage of $per_vote";
} 

[CHeeSeBLiND]

thx alot

[lynlimz]

whoops. while looking back at my post, i noticed an error.

i wrote

$per_vote = $vote/$total_vote; 

but its actually

$per_vote = $votes/$total_vote; 

i missed out the 's' in $votes
I edited my post to reflect the changes. sorry.

[freddydoesphp]

linlymz,

I don't think your suggestion is going to work. one your percentage result will be a decimal and needs to be multiplied by 100, also no need to run the first query and loop through all the results, this should be a bit more efficient and it results in real numbers.

<?
$db = mysql_connect("localhost", "", "");
mysql_select_db("test");
$countsql = mysql_query("SELECT SUM(votes) as totalvotes from votes") or DIE(mysql_error());
$totalvotes = mysql_result($countsql, 0);
?>
<br>
<?
$result = mysql_query("SELECT ID, value, votes, (votes/$totalvotes) as totalnum from votes");
while($row = mysql_fetch_array($result)) {
    extract($row);
    print "$ID - $value - $votes - ".floor(($totalnum * 100))."<br>";
    }


?>

[lynlimz]

Whoops. forgot about the multiple by 100. haha!
oh..i normally round my numbers off to 2 decimal places.
bleh.

thanks freddy for the better code!!!