tags:

views:

32

answers:

1

Hi there,

Here the story goes...

First of all, the system will check either the user is qualified or not qualified to go for competition by checking their status in database. Then, the user can check their status by login to the website. If the user qualified, the system will display 'You're qualified to competition' and if the user not qualified, the system will output 'You're no qualified to competition'. I have done with this part..

For the second part, the coordinator will finalized the user status and set the value in database field 'StatusConfirm' to 'APPROVED' if the user is really qualified or 'NOT APPROVED' if the user really not qualified for the competition.

How can I overwrite the statement 'You're qualified to competition' to 'APPROVED' or 'You're not qualified for competition' to 'NOT APPROVED' after the coordinator set the new status?

Not sure how to start the codes..should I add more IF statements? Need your advise. Thank you.

A: 

See my comment.

However, just a quick pointer. When checking the result from the database you can use an if statement to determine which message you want to output. Or, you might have the message stored in the DB to begin with...

This will require some knowledge of how the DB is structured and potentially a code review to help you. Which is why I recommend you talk to someone that can sit down next to you.

Chris Lively