Help :\

[Anon]

Ive just spent all night trying to get some php to work and I cant! :\

What im trying to do is output numerically how many times a value appears in a column. I want for example the code to search field "user" and report back in a number how many times "Fred" appeared in that field.

if anyone could write the code for it so I can compare it to mine to see whats wrong, id be greatly appreciative.

Thanks in advance, Stewart

[crusty_php]

select count(*) from table_name where user="Fred"

[Anon]

how do I use this? does something like the following look on track? (im a newbiw 🙂

<?
$db = mysql_connect('localhost','ping','pass);
mysql_select_db("db", $db);
$sql= select count(*) from divx where user="Stewart"
$result = $sql
echo $result
}
?>

where db is my database and divx is my table

Thanks

[Anon]

yes , u do look on track , let me correct u further.

<?
$db = mysql_connect('localhost','ping','pass');
mysql_select_db("db", $db);
$sql= "select count(*) as c from divx where user='Stewart'";
$res = mysql_query($sql , $db);
$result = mysql_fetch_array($res);
echo $result["c"] ;
}
?>

this shld give u the result 🙂

[Anon]

Yipee, it works! thanks a bunch Shilpa, one last thing. What would be the easiest way of returning values of other users aswell? is it easy to add the code so it would return the values for Stewart and Bob ?, I could do it by copying and pasting the code into another file and then do a php include of those two files on my page, I dont spose thats the most practical way 🙂

Cheers, Stew

[Anon]

well , u cannot get the value for both the users from a single query but as u urself have suggested it , u can write a function and pass the value of the user to the function and get the count. Shld look something like this :

$sql= "select count(*) as c from divx where user='$user'";

🙂
Shilpa