Congratulation :-) Ken <ken.poyser@xxxxxxxxxxx> wrote: I found the solution!!! and it works!!! I added the following code inside the while statement $sql1 = "SELECT ORI from $table_name where ORI = '$ori'"; $result1 =@mysql_query($sql1, $connection) or die (mysql_error()); $eagycount = @mysql_num_rows($result1); Thanks you can look at it now and it will show the count http://www.olets3.info/do_testcountORI.php Ken --- In php-objects@xxxxxxxxxxxxxxx, "Ken" <ken.poyser@...> wrote: > > In the missing person table, each record has the data of the agency > that entered the missing person, their telephone number and agency > name (that is part of each record) > > ORI is their NCIC assigned identifier > > Each record has a total of 132 fields in them > > Since the datbase contains certian personal information, I am not > able to give you full > details of the contents of the database since the record also > contain some personal > information of the person that is missing.... The live database > information is located > on a secure part of the website and only certain persons can obtain > the record that > they query on > > Ken > > > --- In php-objects@xxxxxxxxxxxxxxx, Pete <cgrp@> wrote: > > > > In message <fkqubs+cgqk@>, Ken <ken.poyser@> > > writes > > >In the result display window > > > > > >It list the > > > > > >ORI Phone Numuber Ageny Name > > >OK0990000 405 -555-0000 PD SOMEWHERE > > > > > > > > >what I would like to have it list the number of records that > > >OK0990000 has entered whereas it would display > > > > > >ORI # of Rec Phone Number Agency Name > > >OK0990000 45 405 555-0000 PD SOMEWHERE > > > > What's causing confusion, is that your database does not appear to > be > > designed properly. > > > > There should be 2 tables: > > officetable: ORI (assume that this is the office ID), PhoneNumber, > > AgencyName > > missingpersontable: ORI (the office where the person is registered), > > personname, whatever else... > > > > Do you have a record for every single missing person in a single > table, > > with the office name and phone number in each record? > > > > Still not sure what ORI is - is it something that is obvious to an > > american? > > > > -- > > Pete Clark > > > > Sunny Andalucia > > http://hotcosta.com/Andalucia.Spain > > > --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. [Non-text portions of this message have been removed]
