I have a link made available whereas you can see what the results look like http://www.olets3.info/do_testcountORI.php Thanks Ken --- In php-objects@xxxxxxxxxxxxxxx, "Ken" <ken.poyser@...> wrote: > > Here is my php code > > ///////////////////////start of code /////////////////////// > <html> > <head> > > <title>Gathering ORI Data</title> > > </head> > <body> > <h1>Click on ORI and it will display all records entered by that > ORI</h1> > <? > > $db_name = "Missing_Person_Oklahoma"; > $table_name = "Missing_Person"; > $connection = @mysql_connect("mysql","HIDDEN", "PASSWORD") or die > (mysql_error()); > > $db= @mysql_select_db($db_name, $connection) or die(mysql_error()); > $ip_address = getenv("REMOTE_ADDR"); > $sql = "SELECT ORI, Agy_Name, Tele_Num from $table_name group by ORI > having count(ORI) > 0"; > $result = @mysql_query($sql, $connection) or die(mysql_error()); > > > $contact_list = "<ul><strong><body bgcolor =\"#fffacd\"><font face > =\"Courier New\" size=\"3 > \"> ORI &nbs > p;Telephone > Number Agency > Name<p></p>"; > > > > > //loop through results > while ($row = mysql_fetch_array($result)) { > $ori = $row['ORI']; > $agy = $row['Agy_Name']; > $tno = $row['Tele_Num']; > > $contact_list .= "<li><a href=\"show_all_ori_rec.php? > data=$ori\">$ori</a> "; > $contact_list .= "$tno "; > $contact_list .= "$agy "; > $contact_list .= "<br>"; > > $num = $num +1; > > } > $contact_list .= "</ul></strong></font>"; > > echo "$contact_list"; > > $subject = "Oklahoma ORI Listing"; > $body = "A listing of $num ORI's that have Missing Persons > entered in NCIC"; > $body .= "\nwas inquired by the following remote host: "; > $body .= "$ip_address"; > $mailto = "ken.poyser@..."; > mail($mailto,$subject,$body,$header); > > echo "Listing of Oklahoma ORI that have Missing Persons entered in > NCIC"; > echo "<br>There are $num different agencies with entries"; > $timestamp=time(); > $seconds = 6*60*60; > $timestamp-=$seconds; > $localtime = date("m/d/Y H:i:s",$timestamp); > $tz = "CST"; > > $localdate = substr($localtime,0,10); > $localtime = substr($localtime,11,8); > > echo "<br><br>This report was generated on $localdate at $localtime > $tz"; > > > ?> > </body> > </html> > > > > ///////////////////////////end of code////////////////////// > > > > --- In php-objects@xxxxxxxxxxxxxxx, "Muthukumar Selvarasu" > <muthukumar_se@> wrote: > > > > Hi > > > > > > > > give the table structure and sample data > > > > > > > > Thanks, > > > > Muthukumar Selvarasu, > > > > Project Manager (Web Development), > > > > Webmasters Ltd. > > > > _____ > > > > From: php-objects@xxxxxxxxxxxxxxx [mailto:php- > objects@xxxxxxxxxxxxxxx] On > > Behalf Of Ken > > Sent: Tuesday, December 25, 2007 1:22 PM > > To: php-objects@xxxxxxxxxxxxxxx > > Subject: Displaying the count > > > > > > > > I have a SQL that lists the agencies that have records entered. > > > > My SQL is > > > > $sql = "SELECT ORI, Agy_Name, Tele_Num from $table_name group by > ORI > > having count(ORI) > 0"; > > > > I am wanting to show the "count" as well. > > > > I have looked around but I haven't seen anything on how to > > display the count! > > > > Any help would be appreciated! > > > > Thanks > > Ken > > > > > > > > > > > > [Non-text portions of this message have been removed] > > >
