custom tables, custom admin modules, custom scripts on web? - Joomla! Forum - community, help and support

hi new joomla , i'm working using build site me. i'm doing research out. can here appreciated.

basically want this:

-basic informational website skyscrapers(example) 100+ pages
-each page created through joomla standard copy, images etc
-additional info have statistical info stored in database can queried comparing other buildings, top 10 lists etc. lots of different things. info included on main web page each building.

e.g.

site skyscrapers

each page on skyscraper has general info, history, stories, trivia, etc etc. info can entered in normal fashion when creating new page.

however, there statistical data such as:
construction date start
construction date finish
height
# of floors
# of elevators
architect(s)
contractor(s)
square feet of floors
# of windows
others

those items above need stored in numerous tables , able displayed on site other info.

items above used in advanced searches, top 10 lists, comparisons other buildings etc. e.g. 10 tallest buildings in world.

note of these fields of data have more 1 value , stored in table - e.g. there 40 contractors 1 building , each contractor needs stored separately separate table contractors exist.

ideally data entered using 1 page. tables etc can/will functional.

what recommended solution make happen? tables can exist in same db joomla db or in external 1 if needed. looking way when page admin adds new building page, he/she can add of building stats rest of building info , in 1 page.

the tables multiple records per building contractor need looked when editing existing building page , when entering need accommodate adding multiple records when creating new building page.

and mentioned statistical data needs able queried - e.g. select buildings height greater 1000 feet, show differences between building , building b etc.

hopefully have conveyed looking for. people doing work have suggested creating new items each building stat having 40 different fields contractors won't work, when buildings have 1 or 2. if there way have sort of plug-in complex mysql queries , entries add page section ideal.

any suggestions or ideas on for, extensions etc make happen helpful.

thank you

this need ultimate custom approach, or might done in 1 of cck extensions (as quite easy create custom content building stat).
you mention tables, straighten bit - see 1 table building stats , possibly 1 contractors. data mention might set in 2 tables, rest of mechanics need right filtering.

i think can hard, first check cck's, when not enough end own custom extension fulfill these tasks.

i used check 1 cck (seblod), don't use can't give right choice.

ps: heavy statistical data may think external plugin/whatever/cron cache data.