09-26-2007, 08:21 AM
|
#1 (permalink)
|
|
The Contributor
Join Date: Sep 2007
Location: Finland
Posts: 45
Thanks: 3
|
Count multiple tables + same row name
Hi!
How to count from multiple tables where all has same rowname?
table: commentsimage
rowname: poster
table: commentsprofile
rowname: poster
table: commentscafe
rowname: poster
I have tryed something like this which doesn't work tho..
PHP Code:
$count = mysql_query("SELECT COUNT(poster) FROM commensimage, commentsprofile, commentscafe WHERE poster = $poster") or die(mysql_error());
Thanks for all help! |
|
|
Join the friendly bunch on IRC...
Threaded Mode
