count rows in several "similar" tables

[Dalaker]

I'm using table1 table2 table3 etc..

what i want is to count all rows called 'pic'

I'm currently using this soulution

$result = mysql_query("SELECT pic FROM table1 UNION ALL SELECT pic FROM table2 UNION ALL SELECT pic FROM table3");
$num_rows = mysql_num_rows($result); 
echo"$num_rows";

this way are getting to advanced to use when theres beeing added more tables.

I'm wondering if theres a way like the one underneath that will work.. (i know the one underneath wont work, just use it to state a example) without doing a loop or something advanced 😉

$result = mysql_query("SELECT pic FROM `album*`");

Thanks in advance

[Lars_Berg]

Sounds like a design problem. Why do you have multiple tables?

[Dalaker]

because i got one table for each album and gallery got it's own table, this code is for my gallery.. maybe i should redo my tables and put all albums into one table..

[ultraslacker]

Lars is right, this is a design problem. Albums should be contained in one table.

[Dalaker]

I've started a total redesign of my album and gallery listening, so the problems are solved..

Thanks 😃