$addresscities=array();
// Make an empty array
$resultrows=file("address.txt");
// This creates an array of lines of the file, one element per line
foreach ($resultrows as $line) {
$row=explode("\t",$line);
// Chop up the row into 3 fields separated by the tab (\t) character
// You must use double quotes for PHP to read \t as a tab character
$addresscities[$row[2]]= $addresscities[$row[2]]+1;
// Add a count of one to the value in $addresscities[`cityname`]
// If an array element like that does not exist it will be created
// and one added to its initial value (effctoiely, zero), making a count of 1.
}
// End looping though the result rows
ksort($addresscities);
// Sort the array keys (city names) alphabeticallyYou now have an array containing entries like : $addresscities["dallas"] ........ 15 $addresscities["mexico"] ........ 1
or whatever. You can do pretty much what you want with that data.
In SQL you would import the file once as a CSV or similar format, then do :
SELECT city, COUNT(city) AS address GROUP BY city ORDER BY city
to get a summary of people in each city. Much simpler, isn't it ? ;-)
I would definitely go with SQL for address data, you can get complex breakdowns of data with almost no re-programming, and this sort of data is made for a database !
Cheers - Neil.
I do not accept mail from hotmail yahoo or other free accounts. Please reply only on list.
All mail from these accounts *will* be bounced and the account blacklisted. Thankyou.
At 19:00 08/08/2003 +0000, you wrote:
Message-ID: <[EMAIL PROTECTED]> Date: Fri, 8 Aug 2003 12:00:12 -0700 (PDT) From: Idur <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-779152822-1060369212=:59102" Subject: selecting data from file with php
hi there,....
i have file address.txt, it's content of address of customer, like this ;
name age city jony 27 new york george 25 dallas mony 23 mexico edward 30 new york budy 22 dallas dennise 21 new york
hox to count the field of city, so the result is, like this
city count dallas 2 new york 3 mexico 1
so i know how many user from a specific city, for the information i am not using mysql. Is that to difficult to do it with out mysql...??
Did php have the function to do selecting data like mysql....???
thanx
======================================================== CaptionKit http://www.captionkit.com : Production tools for accessible subtitled internet media, transcripts and searchable video. Supports Real Player, Quicktime and Windows Media Player.
VideoChat with friends online, get Freshly Toasted every day at http://www.fresh-toast.net : NetMeeting solutions for a connected world.
-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
