SitePoint Sponsor |
|
User Tag List
Results 1 to 1 of 1
-
Aug 20, 2009, 03:43 #1
- Join Date
- Aug 2009
- Posts
- 299
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Displaying data in Repeat Region: Help please!
I have a MySQL table called 'services':
tbl_services
servid
servlangs
servlangt
'servlangs' and 'servlangt', get their values from a table 'language':
tbl_language
langid
langname
I can add records to the service table with no problem.
The trouble starts when I present the records in a repeat region. I have a recordset, to filter the data:
rsServices
SELECT tbl_service.servid, tbl_service.servlangs, tbl_service.servlangt, tbl_language.langname as servlangsource
FROM tbl_service, tbl_language
WHERE tbl_language.langid=tbl_service.servlangs
The repeat region is as follows:
rsServices.servtitle, rsServices.servlangsource, rsServices.servlangt
I've used the 'as servlangsource' to show the language name, instead of the id, but I can't figure out how to do the same for the 'servlangt' value.
Can anybody help?
Bookmarks