Help with database! :(

ecampsite_co_uk

Hi guys,
You'll prob find this question very simple, but I'm fairly new to PHP and this is doing my nut in!! 🙁
I need my script to add up the number of records in my database which have a specific field name. For example i have a column with "counties" in, i would like to add up the records with the county Somerset in that cell. I'm thinking its something along the lines of if $county = Somerset => count $county
Im using a flatfile database, since Im not using a lot of data. Below is my code so far without this sum function...

<?php
$fp = fopen('data.csv','r'); 
if (!$fp) {echo 'ERROR: Unable to open file.</table></body></html>'; exit;}

while (!feof($fp)) { 
$line = fgets($fp, 2048); 
list ($country, $county, $campsite, $town, $address, $postcode) = split ('\,', $line); 

NEED YOUR FUNCTION HERE PLEASE!! :)

}
$fp++; 
}

fclose($fp); 
?>

Thank you so much for ay help that you can offer,
Craig

Weedpacket

Well, if you were doing it by hand how would you do it? You'd look through each record in turn. "Is this county the one I'm looking for? No. Is this county the one I'm looking for? No. Is this county the one I'm looking for? Yes. Is this county the one I'm looking for? No...." and keep a tally of the number of times the answer is yes.

So you get the computer to do that.

<?php
$looking_for = 'Somerset';
$number_found = 0;

$fp = fopen('data.csv','r');
if (!$fp) {echo 'ERROR: Unable to open file.</table></body></html>'; exit;}

while (!feof($fp)) {
$line = fgets($fp, 2048);
list ($country, $county, $campsite, $town, $address, $postcode) = split ('\,', $line);

if($county==$looking_for) $number_found++;

}
$fp++;
}

fclose($fp);
?>

And you might want to look at [man]fgetcsv[/man], just to simplify things a bit.

ecampsite_co_uk

thank you, for that, I tried it, the only thing wrong tho, is it doesnt print out anything on screen. Ive tried

echo ''.$number_found.'';

but it then prints out the findings as the computer is reading it, i.e 00001111222233333. Is there anyway to just end up with the last number, because that will always be the total.

Thank you again,
Craig

Weedpacket

Yes, since you don't know what $number_counted would be until after you've done the counting, you'd echo the result after you've counted, not while you're counting.

Simple logic, that.