Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Search Engine - write review
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Search Engine - write review

 Post Reply Post Reply
Author
urko View Drop Down
Groupie
Groupie
Avatar

Joined: 23 September 2004
Location: Slovenia
Status: Offline
Points: 160
Post Options Post Options   Thanks (0) Thanks(0)   Quote urko Quote  Post ReplyReply Direct Link To This Post Topic: Search Engine - write review
    Posted: 18 July 2005 at 10:20am
Hey all,

Has any1 tried to add "Write review" to Search engine??
The reason I'm asking is, that I would like to use search engine db for my products but would also like beside voting to write reviews.

Any Idea how should I make this?

Thanks,


Urko
Back to Top
ub3rl337ch3ch View Drop Down
Senior Member
Senior Member
Avatar

Joined: 16 February 2005
Location: Australia
Status: Offline
Points: 341
Post Options Post Options   Thanks (0) Thanks(0)   Quote ub3rl337ch3ch Quote  Post ReplyReply Direct Link To This Post Posted: 18 July 2005 at 7:05pm

create a table which includes a long field (100s of characters) and an id field. then whenever someone posts a review, add a record to this table with the id of whatever they're reviewing and the review itself. you could also have a field for poster (username or handle), time of post (=now()) and title of review, if you want something slightly less basic.

 
Then it'd just be a matter of doing a query for whatever fields you want where id = the id of the product being viewed, using that to open a rs, and doing 'do until vrec.eof' and 'vrec.movenext' to fill out subsequent rows of reviews...
Back to Top
pmormr View Drop Down
Senior Member
Senior Member


Joined: 06 January 2003
Location: United States
Status: Offline
Points: 1479
Post Options Post Options   Thanks (0) Thanks(0)   Quote pmormr Quote  Post ReplyReply Direct Link To This Post Posted: 19 July 2005 at 12:57am
the best field type to use for reviews and stuff is called a "memo field" in access. check the help files to see how to change it.
Back to Top
urko View Drop Down
Groupie
Groupie
Avatar

Joined: 23 September 2004
Location: Slovenia
Status: Offline
Points: 160
Post Options Post Options   Thanks (0) Thanks(0)   Quote urko Quote  Post ReplyReply Direct Link To This Post Posted: 19 July 2005 at 12:50pm
Not sure i understand exactly what u mean.

So I should make new table with cells: ID, TITLE, REVIEW, DATE and then I have to connect it with RS??Confused


I think I would need little more help Confused
Urko
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.