Template:Sports: Difference between revisions
Jump to navigation
Jump to search
Kamalanath (talk | contribs) No edit summary |
Kamalanath (talk | contribs) No edit summary |
||
| Line 2: | Line 2: | ||
|server=drck-db | |server=drck-db | ||
|from=teamsofyear | |from=teamsofyear | ||
|where=TeamTypeNo='{{{ | |where=TeamTypeNo='{{{2}}}' | ||
|limit=100 | |limit=100 | ||
|order by=Year ASC | |order by=Year ASC | ||
| Line 8: | Line 8: | ||
}} | }} | ||
{{#for_external_table:<br/> | {{#for_external_table:<br/> | ||
==[[{{{ | ==[[{{{1}}} {{{Year}}} |{{{Year}}}]]== | ||
http://images.dharmaraja.net/th{{{TeamPhoto}}} | 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 ).