Im writing a table for points earned in terms of the result that a competitor has been placed. In which case if a competitor comes first and 1 is entered into the database how would it work out the points earned automatically? can i define the points allowed for each position?

You need to create a separate table for POINTS and assign some score for each position. That needs to be implement as a look up table in your database.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.