count it

[manalnor]

Hi,

 

if i've database table as following

 

CREATE TABLE `names` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`name` text NOT NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  AUTO_INCREMENT=215 ;

INSERT INTO `names` VALUES (1, 'name1');
INSERT INTO `names` VALUES (2, 'name2');

 

how to acount number of names so i can write like this

 

Total names : 2

 

if there any something called count function 

[salathe]

if there any something called count function 

 

Sure, you can use the COUNT function in a query.

See http://dev.mysql.com/doc/refman/5.5/en/counting-rows.html

[manalnor]

Actually yes. Google it.

 

thanks

 

$sql="SELECT COUNT(id) FROM names";
$cus=mysql_query($sql) or die($sql);
$count=mysql_fetch_array($cus);

 

now how to write php code that shows the count number from that table ?

[mattal999]

$sql = "SELECT COUNT(id) AS totalid FROM names";
$cus = mysql_query($sql) or die($sql);
$count = mysql_fetch_array($cus);
echo $count['totalid'];