[PHP] What wrong on it?

[RaikND]

First "code .php":

<?php

$host = 'localhost';
$user = 'root';
$pass = 'sh4v13';
$db = 'ldb';

$dbConnect=mysql_connect($host,$user,$pass);
mysql_select_db($db,$dbConnect);

$userOnQuery=mysql_query('SELECT FROM cuentas WHERE id');
foreach ($userOnQuery as $uoQuery){
if ($uoQuery==0)
$nregistrostotal=mysql_result($uoQuery,0,0);
mysql_free_result($uoQuery);
}
mysql_close($dbConnect);

?>

Second ".mysql":

CREATE TABLE `cuentas` ( 
`id` INT NOT NULL auto_increment, 
`email` VARCHAR(40) NOT NULL, 
`pass` VARCHAR(40) NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; 

INSERT INTO `cuentas` (`id`, `email`, `pass`) VALUES (1, '[email protected]', 'pass');

Execute line .php:

            <?php echo 'Total usuarios regristrados: '.$nregistrostotal.''; ?>

i want show total users register with ID value

Help please!

 

[Zonet]

What do you exactly want to do?
Count total users registered?

edit__
maybe this?

<?php

$host = 'localhost';
$user = 'root';
$pass = 'pass';
$db = 'dbname';

$sql = mysql_connect($host, $user, $pass) or die('Cant connect to mysql server!');
mysql_select_db($db) or die('Could not find database!');

$count = mysql_query('SELECT `id`, `email` FROM `cuentas`');
$_count = mysql_num_rows($count);
echo 'We have '.$_count.' registered users!';
?>

But I prefer you to look at MySQLi

<?php
$sql = new mysqli('localhost', 'root', 'pass', 'dbname');
$count = $sql->query('SELECT `id`, `email` FROM `cuentas`')->num_rows;

echo 'We have '.$count.'registered users in our database';
?>

 

[RaikND]

thanks, MySQLi its great... lol, not need make a big code for it, thanks Zonet for you knowledge, reppeeed