Welcome Guest, Not a member yet? Register   Sign In
2 tables, need to select a value from the 2nd to help with the 1st
#1

[eluser]fancms[/eluser]
The way I have my database set up I have a news table and a news category table. When a news article is created, it saves the category assigned to it by the news category id number in a column called cat.

What I'm having trouble with is displaying the name of the category while viewing all the news articles. Currently it only shows the id #; I need to figure out how to show it by its name. I'm not sure if this would require a second query or not.

I am using Template Lite for my templating engine; not sure if that will make a difference. I'm really stumped here; hope someone can point me the right way Smile


Messages In This Thread
2 tables, need to select a value from the 2nd to help with the 1st - by El Forum - 10-27-2007, 11:00 AM



Theme © iAndrew 2016 - Forum software by © MyBB