Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

ASP.NET Forum


You are currently viewing our ASP.NET Forum as a guest. Please register to participate.
Login



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

Posts: 39
Name: Rob
Trades: 0
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
 
 
Register now for full access!
Old 02-18-2007, 07:56 PM Re: displaying messages on a details page
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
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!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 02-19-2007, 09:43 AM Re: displaying messages on a details page
Experienced Talker

Posts: 39
Name: Rob
Trades: 0
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, 03:14 PM Re: displaying messages on a details page
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
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!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 02-19-2007, 04:22 PM Re: displaying messages on a details page
Experienced Talker

Posts: 39
Name: Rob
Trades: 0
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 Search this Thread
Search this Thread:

Advanced Search

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

BB 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.28158 seconds with 12 queries