xoligy Posted February 26, 2010 Share Posted February 26, 2010 Is it possible to count the rows of 5/6 tables and then return the result? Everything ive looked at dont look right lol all the tables are identicle just the names and the data entered is different. Here is how the db looks Table > setup Melee - id, item, att, def, limited Guns - id, item, att, def, limited another anothre Break down: id - primary key, auto inc. item - name att/def numbers limited - is either blank, favor, blackmarket etc etc Now i want to count all records in limited that are = to "favor" in all tables, is this possible or am i going to need seperate querys then add them up? Just thought maybe db doing it be better tho i could be wrong Quote Link to comment https://forums.phpfreaks.com/topic/193473-counting-a-row-in-multiple-tables/ Share on other sites More sharing options...
fenway Posted February 26, 2010 Share Posted February 26, 2010 UNION then COUNT(*)? Quote Link to comment https://forums.phpfreaks.com/topic/193473-counting-a-row-in-multiple-tables/#findComment-1018590 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.