[Youmay]

Hi friends i will trying to my website show total registered users but script was not working so i want help here is the script -

<?php session_start(); include_once 'config.php'; 
$number = my_query(mysql_query=("SELECT COUNT (uid) AS number FROM `users`"));
$row = mysql_fetch_array($number);
echo "There are total $row['uid'] registered users. 
{
?>
<?
}
?>

any one tell me what wrong in this script.

Its showing an error like this -
syntax, error, T_string Variable
a*******/public_html/index.php

[andrewsw]

You haven't told us what line number causes the error, and what line this refers to in your posted code.

However,

echo "There are total $row['uid'] registered users.

you haven't completed this line. The lines that follow this one are also odd.

BTW I would also back-tick a field name like `number`.

[Dormilich]

SELECT COUNT (uid) AS number FROM `users`

in this SQL code the count comes up under the "number" index, since you named it that way.