OK,
here is the answer in (unedited except for comments)code:
$query = select count(vid) as total_qs from poll_vote where pid = $pid;
// count the number of fields in the table
$result = mysql_query($query) or die(Query failed: $querybr .
mysql_error());
$row = mysql_fetch_array($result);
$query = 'select count(poll_vote.vid) as total, (count(poll_vote.vid) /
'.$row['total_qs'].' * 100) as percentage, poll_option.poption from
poll_vote, poll_option where poll_vote.oid = poll_option.oid and
poll_vote.pid = '.$pid.' group by poll_vote.oid';
/*
count the number of rows for a id or something then devide it by the number
of total rows. then mulitply it by 100.
use group by clause to group results by the thing you want to group it by
*/
$result = mysql_query($query) or die(Query failed: $querybr .
mysql_error());
$num_results = mysql_num_rows($result);
for ($i=0; $i $num_results; $i++)
{
$row = mysql_fetch_array($result);
echo 'trtd'.$row['poption'].' - ';
echo $row['total'].' Votes./tdtdimg alt=line.gif (1K)
src=images/line.gif height=15
width='.$row['percentage'].''./td/tr\n;
}
here it is in the two SQL queries + required code to get var:
$query = select count(vid) as total_qs from poll_vote where pid = $pid;
// count the number of fields in the table
$result = mysql_query($query) or die(Query failed: $querybr .
mysql_error());
$row = mysql_fetch_array($result);
$query = 'select count(poll_vote.vid) as total, (count(poll_vote.vid) /
'.$row['total_qs'].' * 100) as percentage, poll_option.poption from
poll_vote, poll_option where poll_vote.oid = poll_option.oid and
poll_vote.pid = '.$pid.' group by poll_vote.oid';
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
César aracena [EMAIL PROTECTED] wrote in message
002901c23716$b352a020$84c405c8@gateway">news:002901c23716$b352a020$84c405c8@gateway...
Hi JJ. I know we all should do what you did, but I've seen this kind of
mails quite a lot lately in these lists. I'm sure that many of you, like
me, keep these mails for further reading and reference... it would be
nice if you also state what was the answer to your original question. I
mean, if you came up with a question that some of us might have in the
future, it would be nice to have the answer off-line (in our mail soft)
instead of going on-line for search... Shear it with others!
Thanks, C.
-Original Message-
From: JJ Harrison [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 7:03 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Percentage...
Plz ignore this. found it after more searching...
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
Jj Harrison [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
How, using the group by and where statments can I return the
percentage
of
something?
ie:
pid| oid| uid |
1 |2 |1
1 |2 |1
1 |2 |1
1 |1 |1
would return
oid | percent
2| 75
1| 25
Thx,
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
