Order the query by the category, when the category changes echo out the new
category like a heading
";
$old_cat = '';
while ($rows = mysql_fetch_array($result))
{
if ($rows['cat'] != $old_cat)
{
echo "" . $rows['cat'] . "";
echo "";
$old_cat = $rows['cat'];
}
echo "". rows['it
Hey all,
I have a table like this:
boroughID Area
=
1 Chelsea
1 East Village
1 West Village
1 So Ho
2 Prospect Park
2 Brooklyn Heights
3 Prospect Heights
What I want to kno
Why don't you use a where instead of a group function?
On 7/22/06, Skip Evans <[EMAIL PROTECTED]> wrote:
Hey all,
I have a table like this:
boroughID Area
=
1 Chelsea
1 East Village
1 West Village
1 So Ho
2
SELECT count(*) FROM `bsp_area` GROUP BY boroughID
Bastien
From: Skip Evans <[EMAIL PROTECTED]>
To: Php-Db
Subject: [PHP-DB] Using MAX with COUNT?
Date: Sat, 22 Jul 2006 13:48:43 -0600
Hey all,
I have a table like this:
boroughID Area
=
1 Chelsea
1
OK, so I have this text file that holds a list of ip addresses like this:
127.0.0.1,127.0.0.1,127.0.0.1,127.0.0.1,127.0.0.1
Currently, here is my code:
$file = 'ip.txt';
$fh = fopen($file, 'r');
$theData = fread($fh, filesize($file));
fclose($fh);
$ips = array($theData);
Since it's a nume
OK, well I did a debug and this is whats coming out:
Array
(
[0] => 127.0.0.1,127.0.0.1,127.0.0.1
)
Should I use fgets?
On 7/22/06, Dave W <[EMAIL PROTECTED]> wrote:
OK, so I have this text file that holds a list of ip addresses like this:
127.0.0.1,127.0.0.1,127.0.0.1, 127.0.0.1,127.0.0.1