mysql count problem

[pcw]

Hi, I am trying to count the number of usernames recorded in my members database:

 

I got this code:

 

<?php

include_once("data/mysql.php");

$mysqlPassword = (base64_decode($mysqlpword));

$con = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die(mysql_error());
mysql_select_db("$dbname", $con) or die(mysql_error());


$query = "(SELECT COUNT(username) FROM members)";
  
$results = mysql_query($query) or die ("Error reading from database");
$username = mysql_fetch_array($results);

echo "$username";

?>

 

but echoing $username gives me

 

Array

 

so I echoed $results and that gives me

 

Resource id #3

 

I know I have probably written the sql query incorrectly, so any help will be much appreciated.

 

Paul

[Pikachu2000]

$username = mysql_fetch_array($results);

 

This puts the returned values into an array. To access those values, you need to reference them by their array indices.

 

$array = mysql_fetch_array($result);
echo $array['username'];

[pcw]

Hi Pikachu2000, thanks for your reply,

 

I tried as you said and all I get is a blank screen.

 

I just want it to return the number of usernames

 

eg. 4

 

Thanks

 

Paul

[gristoi]

<?php
include_once("data/mysql.php");

$mysqlPassword = (base64_decode($mysqlpword));

$con = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die(mysql_error());
mysql_select_db("$dbname", $con) or die(mysql_error());


$query = "(SELECT COUNT(username) AS Total FROM members)";
  
$results = mysql_query($query) or die ("Error reading from database");
$username = mysql_fetch_array($results);

echo $username['Total'];



?>

 

[pcw]

gristoi you are a genius!

 

Many thanks 

[Pikachu2000]

Sorry, forgot to alias the field . . .

[pcw]

no probs