[SOLVED] Check how many articles and display...

[Aureole]

I want to query the MYSQL database for all news articles then show something like:

 

We have a total of x news articles.

 

How would I go about doing this?

[Aureole]

I know I need to do this...

 

$query = "SELECT id FROM news";
$result = @mysql_query($query) or die(mysql_error());

 

And I realize I need to do something with "mysql_num_rows" but I don't know how.

[vbnullchar]

<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "We have a total of $num_rows ews articles.\n";

?> 

 

 

http://www.php.net/mysql_num_rows

[Aureole]

Thankyou very, very much.