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.
<?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.