database setup?

for checking one table against another and adding data to both tables

Page 1 of 1

3 Replies - 1709 Views - Last Post: 24 November 2006 - 06:51 AM Rate Topic: -----

#1 °•Guru•°  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 25
  • Joined: 17-October 06

database setup?

Post icon  Posted 17 October 2006 - 09:39 PM

hey,

how would i setup a database tables my issue is this:

i have one table with my questions in it and the other table will the users email address which will show the question ID from the questions table aswell as email so i can run a query

"don't show the same question they have seen next time they play"

i'll need a cookie to store this probably a server side cookie
any ideas on the query to structure it if i need functions etc??

cheers in advance :)

Is This A Good Question/Topic? 0
  • +

Replies To: database setup?

#2 Trogdor  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 15
  • View blog
  • Posts: 627
  • Joined: 06-October 06

Re: database setup?

Posted 18 October 2006 - 08:49 AM

A serverside cookie... i have never heard about that, i dont think hat is what you will want to use.

Those users, are they logged in in some way?
If so you can use their user id to build up a table of what user saw what question (and when)

If not then cookies might work, but client side (normal) cookies for sure.
Was This Post Helpful? 0
  • +
  • -

#3 °{Guru}°  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 01-November 06

Re: database setup?

Posted 06 November 2006 - 03:02 PM

cool thanks but yeh server side cookies are pretty much the same thing as client side but they are controlled by the server so users cannot turn them off etc...
Was This Post Helpful? 0
  • +
  • -

#4 Skinnyarms  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 32
  • Joined: 18-November 06

Re: database setup?

Posted 24 November 2006 - 06:51 AM

I know coldfusion can store SESSION variables in memory and CLIENT variables in the registry that can both act sort of like cookies. I've never heard of anything called server side cookies, I'm not saying your wrong, I'd just be interested to know what language your using so I can compare and contrast how it works to what I'm familiar with.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1