count database lisitngs

[Neil Trigger]

How would i go about asking the database how many listings there are with
the same "Town" field?

I want a page that eventually says:
"We found XXX listings in ZZZ"
Where XXX is the number of listings found and ZZZ is the town.

Thanks,
--
¿ Trigger ?
http://www.magic2k.com/
http://www.oddmap.co.uk

[roger smith]

try this:

-------------------------------------------------------------------
$sql = "SELECT * FROM mytable WHERE town = \"$mytown\" ";
$query = mysql_query($sql);
$num_rows = mysql_num_rows($query);
echo "We found " .$num_rows ." listings of " .$mytown;
-------------------------------------------------------------------

look here for more ::
http://www.php.net/manual/en/functio...l-num-rows.php

is that what you want ?

Neil Trigger wrote:

How would i go about asking the database how many listings there are with
the same "Town" field?

I want a page that eventually says:
"We found XXX listings in ZZZ"
Where XXX is the number of listings found and ZZZ is the town.

Thanks,
--
¿ Trigger ?
http://www.magic2k.com/
http://www.oddmap.co.uk

[Gerard]

mysql_num_rows() was not always so efective.

If it fails try this:

$count = mysql_fetch_array(mysql_query("select count(*) from table where
town=example"));
echo "$count";

It has been always useful for me.

Regards

Domin

[Tim Van Wassenhove]

On 2003-12-18, Gerard <ga******@WYTNIJwp.pl> wrote:

mysql_num_rows() was not always so efective.

If it fails try this:

$count = mysql_fetch_array(mysql_query("select count(*) from table where
town=example"));
echo "$count";

I think you are doing "weird stuff" to get the count(*) ...

$result = mysql_query("SELECT COUNT(*) as count FROM TABLE WHERE Town='example'");
$row = mysql_fetch_assoc($result);
Now it is in $row['count'] ;)

--
verum ipsum factum

[lazo]

I think it's better to use ...

$sql = "SELECT count(*) as numRows FROM mytable WHERE town = \"$mytown\" ";
$query = mysql_query($sql);
$aRow = mysql_fetch_array($query);
echo "We found " .$aRow[numRows] ." listings of " .$mytown;

.... because in this case MySql don't return useless data.