Show Values on HTML

THE DON · #1 (**permalink**) 12-06-08, 09:50

I have a vbulletin forum. What I need is, that last value from table "userid" shows on a HTML page using "include php"

Actually I want to show the number of users on the main page of my website, which in HTML format. But that should be in the form of "2,000" if the last value is 2000

Is it possible?

Right now I am using this PHP to extract the value and then using include tags in HTML page to fetch this file

PHP Code:


			
<?php

$con = mysql_connect("localhost","username","pass");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }



mysql_select_db("database", $con);



$result = mysql_query("SELECT userid FROM user ORDER BY userid DESC LIMIT 0,1");



echo "<table border='0'>";

echo "<tr>";

while($row = mysql_fetch_array($result))

  {

  echo "<td style='color:#FF0000 '>" . $row['userid'] . "</td>";

  } 

    {

  echo "<td>Users Online & counting. Are you one of them?</td>";

  }

  {

  echo "</tr>";

  }

echo "</table>";



mysql_close($con);

?>

r937 · #2 (**permalink**) 12-06-08, 10:02

SELECT COUNT(*) AS number_of_users
FROM user

mike_bike_kite · #3 (**permalink**) 12-06-08, 12:18

Quote:

Actually I want to show the number of users on the main page of my website, which in HTML format. But that should be in the form of "2,000" if the last value is 2000

you could use the PHP function number_format to add the comma's.

echo number_format( $num_users );

THE DON · #4 (**permalink**) 12-06-08, 13:14

How can I use that? I dont know PHP or MYSQL, so please explain me. The file I am using has been coded by someone else and I found it over internet. Please explain that to me.