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
> >
>
