Question
id from one table showing value from another
I have an article id (rs_comments.id_com) but I would like it
to take this data and collect the value from another table.
I have joined the two tables with:
SELECT * FROM blg_comment_com INNER JOIN blg_article ON idart_com=id_art
WHERE valid_com=1
ORDER BY date_com DESC
rs_comments.idart_com needs to be equal to rs_comments.id_art displaying the value from rs_comments.title_art
How would I go about doing this. There only seems to be an option in DW to do this with a dynamic list/menu but I just want to display the text without option to change it.
Any help much appreciated.
I have joined the two tables with:
SELECT * FROM blg_comment_com INNER JOIN blg_article ON idart_com=id_art
WHERE valid_com=1
ORDER BY date_com DESC
rs_comments.idart_com needs to be equal to rs_comments.id_art displaying the value from rs_comments.title_art
How would I go about doing this. There only seems to be an option in DW to do this with a dynamic list/menu but I just want to display the text without option to change it.
Any help much appreciated.
AdChoices