Article View: be.comp.programming
Article #4454Re: PHP-Mysql/ tellen aantal unieke gegevens
From: Dizz
Date: Sun, 27 Jul 2003 09:05
Date: Sun, 27 Jul 2003 09:05
36 lines
1890 bytes
1890 bytes
Ik heb het toch in orde gekregen en dit is de code die werkt :
Of dit echt goede code is of dat er betere manieren zijn weet ik niet maar
het werkt wel.
<?php
$t=0;
$tot = mysql_num_rows($result);
while (list($pt1, $pu1) = mysql_fetch_row($result)){
while (list($pronot, $pronou)= mysql_fetch_row($result2)){
if ($pt1==$pronot AND $pu1==$pronou){
$t++;
}
}
$perc=round((($t/$tot)*100),2);
$lijnbreedte=($t*30);
echo("<tr><td>$pt1 - $pu1</td><td><img src=\"line9.gif\"
width=\"$lijnbreedte\" height=\"6\" alt=\"Percentage\" border=0> $perc %
[$t] $tot</td></tr>\n");
$result2 = mysql_query($query2) or die (mysql_error());
$t=0;
}
?>
Technical Details
Message-ID:
<3f2395e1$0$300$ba620e4c@reader0.news.skynet.be>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!skynet.be!skynet.be!louie!tlk!not-for-mailReferences:
<3f22a2cc$0$293$ba620e4c@reader1.news.skynet.be> <dau5ivk7unmbsucflg1u53vqp17ueoh5in@4ax.com>Show Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII-7-bit X-Google-Thread: 107324,4917c961a5a2eb8c X-Google-Attributes: gid107324,public X-Google-Thread: fcea4,4917c961a5a2eb8c X-Google-Attributes: gidfcea4,public X-Google-ArrivalTime: 2003-07-27 02:05:50 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!skynet.be!skynet.be!louie!tlk!not-for-mail From: "Dizz" <voetbaltepel@skynet.be> Newsgroups: be.comp.programming,nl.comp.programmeren References: <3f22a2cc$0$293$ba620e4c@reader1.news.skynet.be> <dau5ivk7unmbsucflg1u53vqp17ueoh5in@4ax.com> Subject: Re: PHP-Mysql/ tellen aantal unieke gegevens Date: Sun, 27 Jul 2003 11:05:34 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Lines: 38 Message-ID: <3f2395e1$0$300$ba620e4c@reader0.news.skynet.be> Organization: -= Belgacom Usenet Service =- NNTP-Posting-Host: 80.201.1.7 X-Trace: 1059296737 reader0.news.skynet.be 300 80.201.1.7:1102 X-Complaints-To: usenet-abuse@skynet.be