Need simple line of Php / Mysql code

[Alex.]

[resolved] Need simple line of php / mysql code

hi,
i have litterally started learning php today, and im trying to compile a simple script.

i nèed a line of php code that returns the no. of rows in a table.

if i get this before 7:30pm (40 mins @ time of writing) i will donate the author 10np.

i know thats not a lot, but im not asking much.

 

[superprogrammer]

From php website
http://us3.php.net/mysql_num_rows

<?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 "$num_rows Rows\n";

?>

 

[Cybo]

Here you go sir.

// You should have the following line.. 
$result = mysql_query($sql);

// This is the line you want to get the rows:
$rows = mysql_num_rows($result);

$rows will store how many rows the query has. Hence the rows stored in $result

Regards,
Richard.

 

[Alex.]

thanks.
thats all i need