how 2 do this?(mysql)
Posted: Sat Sep 14, 2002 3:34 pm
hi,
i am makeing a forum and i have ranking table
here is ranking table layout:
ID:1
title: user
required_posts = 0
ID: 2
title: coder
required_posts: 15
____________________
here is users table:
ID: 1
Username: user1
posts: 4
______________________
so, user1 has a rank title of user by looking at this but how do i do this in a query? how do i get the correct rank title based on number of posts?
i can't seem to understand that
thanks alot for your time
i am makeing a forum and i have ranking table
here is ranking table layout:
ID:1
title: user
required_posts = 0
ID: 2
title: coder
required_posts: 15
____________________
here is users table:
ID: 1
Username: user1
posts: 4
______________________
so, user1 has a rank title of user by looking at this but how do i do this in a query? how do i get the correct rank title based on number of posts?
i can't seem to understand that
thanks alot for your time