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