Count String Help??

Andyr6381

Hey.

I am trying to write a script to output the number of times the string home appears in the field brenchley, this is the scripts I am using

<?php require_once('../Connections/bb4b.php'); ?>
<?php
mysql_select_db($database_bb4b, $bb4b);
$query_home = "SELECT COUNT(*) FROM registration WHERE (brenchley = 'home') ";
$home = mysql_query($query_home, $bb4b) or die(mysql_error());
$row_home = mysql_fetch_assoc($home);
$totalRows_home = mysql_num_rows($home);
?>

<?php
echo ("mysql_free_result = ");
echo mysql_free_result($home);
echo ("<p> </p>");
echo ("home = ");
echo ($home);

The output results i am getting are:

mysql_free_result = 1

home = Resource id #2

I know that there are 2 homes in the field brenchley and that the query works, I have updated my php and this makes no differance.

Cheers Andy

Lars_Berg

$query_home = "SELECT COUNT(*) FROM registration WHERE brenchley = 'home'";

Andyr6381

Ok.

I guess you are suggesting that I remove the hyphens,

I tried this and it made no differance, I know the query works fine. just cant get the result.

Any thing else it could be?

cheers Andy

[deleted]

How about...

$query_home = "SELECT brenchley FROM registration WHERE brenchley LIKE 'home'";

$result = mysql_query($query_home);
$result_count = mysql_num_rows($result);
echo $result_count;

Lars_Berg

$row_home = mysql_fetch_row($home);
$totalRows_home = $row_home[0]; 
//
echo $totalRows_home;

Bunkermaster

...
$query_home = "SELECT COUNT(*) FROM registration WHERE (brenchley = 'home') ";
$home = mysql_query($query_home, $bb4b) or die(mysql_error());
$row_home = mysql_fetch_assoc($home);
$totalRows_home = mysql_num_rows($home);
...

Well what you do in that case is count the records in database (which will return only1 row) and count that one row.

Lars Berg is right BUT I'd have done a bit differently for maintenability purpose :

$query_home = "SELECT COUNT(*) as count FROM `registration ` WHERE (`brenchley` = 'home') "; 
$home = mysql_query($query_home, $bb4b) or die(mysql_error()); 

$row = mysql_fetch_array( $home );
echo $row['count'];

Andyr6381

Thanks Lars that worked great,

regards
Andy