4 replies to this topic

[wheay]

hi friends,

im having a problem do i need to create 2 tables or 2 database for this?

i want to create a game where participants need to register before they could guess.
my table structure: (i dont know if its right)

Registration table:
userid(auto), username, fname, lname, password

guess table:
userid(auto), guess1, guess2, guess3, date_entry(auto)

the link for the user and the game is the userid

and i need to create a display(admin) for the game.

sample output:
Name Guess1 guess2 guess3 date entry
james 57 54 49 Apr. 30, 2011

how do i create the sql for the table and the query for linking the 2 tables?

Thank you. hope you could help me.

[wheay]

any help?
Thank you.

[Orjan]

SELECT name, guess1, guess2, guess3, date_entry 

FROM registration r

JOIN guess g ON r.userid = g.userid

[wheay]

hi,

how will php know if the 3 numbers entered by the currently login user, know that it is his guess.

[Orjan]

add a where statement on

WHERE r.userid='$loggedinid'

at the end of that statement where $loggedinid is the id of logged in user.