2BestGamer9
New Member
I need to make a script which will fetch data from one table and produce XML or JSON response. Now, the table has data from other tables (FKs) represented by \[code\]int\[/code\] value. Would it be wrong to make a response which returns both FKs and its values from other tables? I am not sure what is the bets programming practice. For example, a response could look like this (XML)\[code\]<item> <guid>1738291029</guid> <title>Some title</title> <link>http://www.site.info</link> <description>A description</description> <id>4</id> //FK int from main table! <category>News</category> //String value from other table!</item>\[/code\]In here, I return the FK int value and its corresponding value from the linking table.