in need of a PHP/MySql expert!!!?

A

Andrew Blake

New member
Hi, basically I have this piece of php which will count and display the amount of rows within a table:
<?php

$link = mysql_connect("localhost","****","****");

mysql_select_db("****", $link);

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

echo "$num_rows reviews ";

?>


This all works, but I want it to count it not just from the table "lincoln" but from more than 1, how can I add this to the code?

Thank you,
Merry Christmas,
Andy.
 
Back
Top