Reply
displaying messages on a details page
Old 02-18-2007, 06:31 PM displaying messages on a details page
Experienced Talker

Posts: 39
Name: Rob
i have a website for musicians each musician has their own details page that displays all their details i want to create a section that will display messages to the band and the band can answer these comments and they will be displayed on the same page it will be like a guestbook for each musician how do i do this do i just need to link the database tables or what? im not sure if anyone can help please let me know. cheers
starsearch is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
     
Old 02-18-2007, 06:56 PM Re: displaying messages on a details page
chrishirst's Avatar
Super Moderator

Posts: 12,741
Location: Blackpool. UK
Personally I would rejig some forum code.
Snitz Forum is in ASP and fairly straight forward to modify.

It would also be very simple to have some code that pulled snippets from the threads onto the relevant pages.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 02-19-2007, 08:43 AM Re: displaying messages on a details page
Experienced Talker

Posts: 39
Name: Rob
how would i link the two different tables i have an artists table and the table from the snitz would need to be linked to know what messages to display. what do i do
starsearch is offline
Reply With Quote
View Public Profile
 
Old 02-19-2007, 02:14 PM Re: displaying messages on a details page
chrishirst's Avatar
Super Moderator

Posts: 12,741
Location: Blackpool. UK
you just need a mapping table between artists and threads, how depends on how you identify the artists.

In snitz the threads are in the "topics" table and replies are in the "reply" table, and the linking field in reply is topic_id.

So you would need to pull the artist ID, JOIN the topics ON artistID and JOIN the replies to topics.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 02-19-2007, 03:22 PM Re: displaying messages on a details page
Experienced Talker

Posts: 39
Name: Rob
SELECT *
FROM Artisttable
WHERE ID = MMColParam

this displays the details of the artists

SELECT *
FROM artistsgb
WHERE ID = MMColParam
ORDER BY ID ASC

is this what its meant to look like
i have joined the two tables up in msaccess from id in the artists table to id in the gbartists table
starsearch is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to displaying messages on a details page
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.14444 seconds with 13 queries