[SOLVED] Counting records

[DrTrans]

need a simple way to count records in a sql statement

 

basically

 

in my table i have a row called " skey " for everytime  that key is entered in the database i wanna know how many times it is

 

thanks

 

 

[cags]

SELECT COUNT(column_name) FROM table_name WHERE column_name='skey'

[DrTrans]

Heres my code

 

<?php 
    
    $connect = mysql_connect("localhost","damgears_evil","damgears");
     mysql_select_db("damgears_evil");
     $queryreg = mysql_query("COUNT (*) FROM titles");
   
    
    ?>
    
    <p align="center">There have been <?php echo"$amountitles"; ?> set with our Titler.</td>

 

 

[DrTrans]

$amountitles isnt set. I need to make $amountitles = ( amount of titles counted)

[cags]

a.) I believe COUNT cannot be used like that and you should infact use SELECT COUNT.

b.) At no point in your code do you seem to set $amounttitles to any value.

 

mysql_query always returns a resource object even if logically you know it will just be one value. You will need to use $row= mysql_fetch_array($queryreg); and $amounttitles = $row[0];

[Psycho]

From my interpretation of your first post, I think you are saying there will be multiple records with the same 'skey' value and want to know how many times each one appears. If that is the case you will need something a little different:

 

SELECT skey, COUNT(skey) as count
FROM titles
GROUP BY skey

 

That will return a separate record for each unique value along with the number of times it appears.