simple count code

[jacko_162]

Looke on the PHP manual for the "count" function and it has confused me.

 

it seems to count arrays more than anything.

 

i have a small site and i wanted to display how many items are contained within a Database table.

 

for example i want it to count the amount of users are in the user table.

 

and i then need to echo that amount + 100.

 

Can someone help me with the code.

 

i have already included a database connect script within the header of the page with includes etc.

 

Help would be appreciated. but i would like to know how the code works else i will never learn. 

[jacko_162]

ok i managed to count the rows and echo that amount.

 

how can i add a number to the echo for example how would i add 100 to the amount and echo the "new" amount?

 

 

here is my working code;

<?php

// Query the DB and perform the count
$result = mysql_query("SELECT * FROM members");
$num_rows = mysql_num_rows($result);

// Display the results
echo $num_rows; 
?>

[Pikachu2000]

echo ($num_rows + 100);

[WatsonN]

Try this

 

$result = mysql_query("SELECT * FROM table1");
$num_rows = mysql_num_rows($result);
$number2 = 100;
$number = $num_rows + $number2;
echo "$number Rows\n";

 

[jacko_162]

Try this

 

$result = mysql_query("SELECT * FROM table1");
$num_rows = mysql_num_rows($result);
$number2 = 100;
$number = $num_rows + $number2;
echo "$number Rows\n";

 

 

worked thank you. =)