Forums

This topic is locked

Some help with a Creating Feedback based page

Posted 13 May 2003 22:07:25
1
has voted
13 May 2003 22:07:25 ibraheem youssef posted:
ok i'm creating something like a directory with many advertisers on it , and when you sign up as a user your enabled to post a review or comment on each advertisers specific page.

On my Database i have three tables :

Users : with all there details and login info
Advertisers: with details of the servies they offer .. location ..etc

feedback : this is where i stopped at this is where i want the feedback to be

i pretty much am familiar with DMX

but to cut things short , heres what i'm seeking to find out :

1. how can i make it so when a user is logged in he can post a message directly , then after that it shows his user name next to the post

2.if i have one table for all the posts , how can i sort each post to the desired advertiser it was posted to. ?

I REALLY appreciate any help i can get ...

thankyou

Replies

Replied 15 May 2003 18:09:33
15 May 2003 18:09:33 Dan Berdusco replied:
If I understand you correctly, your feedback table would need to have two fields like UserID and AdvertiserID which would have many-to-one relationships with the other 2 tables. When a user logs in, his userID can be stored in a session variable and when he posts feedback, then, using a hidden from field, you can have his userID be posted to the feedback table. The process would be similar for the advertisingID.

Reply to this topic