Template:Sports: Difference between revisions
Jump to navigation
Jump to search
Kamalanath (talk | contribs) No edit summary |
Kamalanath (talk | contribs) No edit summary |
||
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{{1}}} | {{#get_db_data: | ||
|server=drck-db | |||
|from=teamsofyear | |||
|where=TeamTypeNo='{{{2}}}' | |||
|limit=100 | |||
|order by=Year ASC | |||
|data=Year=Year, TeamPhoto=TeamPhoto, TeamTypeNo=TeamTypeNo | |||
}} | |||
{{#for_external_table:<br/> | |||
==[[{{{1}}} {{{Year}}} |{{{Year}}}]]== | |||
http://images.dharmaraja.net/th{{{TeamPhoto}}} | |||
}} |
Latest revision as of 16:34, 11 August 2019
The query SELECT Year,TeamPhoto,TeamTypeNo FROM `teamsofyear` WHERE TeamTypeNo='{{{2}}}' ORDER BY Year ASC LIMIT 100 is invalid (Error 1054: Unknown column 'TeamPhoto' in 'field list' Function: EDConnectorRdbms::fetch Query: SELECT Year,TeamPhoto,TeamTypeNo FROM `teamsofyear` WHERE TeamTypeNo='{{{2}}}' ORDER BY Year ASC LIMIT 100 ).