Count rows and print them

Chrysanthus

I wounder what mysql syntax i use to counte row and print the result after counthing the rows or operator???

My db reg_info look like this!!

CREATE TABLE reg_info

(regid int(11) NOT NULL auto_increment,

nickname varchar(32) default NULL UNIQUE,
password varchar(32) default NULL,
firstname varchar(32) default NULL,
lastname varchar(32) default NULL,
birthdate varchar(8) default NULL,
gender ENUM('M','F') default NULL,
email varchar(32) default NULL UNIQUE,
country varchar(32) default NULL,
city varchar(32) default NULL,
gotmember ENUM('yes','no') default NULL,
regdate TIMESTAMP(14) default NULL,

Tracer

Try reading this
In the manual...

http://us2.php.net/manual/en/function.mysql-num-rows.php

Chrysanthus

Thanks it works now

If some on wanna now the code here is my code!

<?php include ("../management/mysqlcondbrr.php");
			$result = mysql_query("SELECT * FROM reg_info",$starta);
			$num_rows = mysql_num_rows($result);
			echo "$num_rows \n"; ?> 

and include file code is here


<?

$starta = mysql_connect ("localhost","whatever","yourpassword"); 
          mysql_select_db ("yourdb"); 
?>