Small bit of coding and database help

[Zowners]

Ok, I installed this onto my forum. After a bit of thought I added 3 radio buttons that appear after the message area. Each of them has a name of "GNU", and they have values of "1", "2" and "3" .

Basically I want to know how I set it up so that this information is stored the database (I know nothing about sql and don't want to screw with it and find out something the hard way), and how I can make an if-conditional work with this database entry when someone views a tutorial or edit's it?

[hambil]

Originally Posted by Zowners

Ok, I installed this onto my forum. After a bit of thought I added 3 radio buttons that appear after the message area. Each of them has a name of "GNU", and they have values of "1", "2" and "3" .

Basically I want to know how I set it up so that this information is stored the database (I know nothing about sql and don't want to screw with it and find out something the hard way), and how I can make an if-conditional work with this database entry when someone views a tutorial or edit's it?

Could you explain in a little more detail what you are trying to do?

[Zowners]

Well basically its a tutorial system where users can post their own. When they post their own, right below the message box I have made 3 radio buttons as per this image:


Just in case its needed, here's the template code (Of the neccessary part):

			<br />
			<input type="radio" name="GNU" value="1" /> <b>Full Release</b> - Any site/person may use <b>and</b> edit your tutorial.
			<br />
			<input type="radio" name="GNU" value="2" /> <b>Partial Release</b> - Any site/person may use yout tutorial.
			<br />
			<input type="radio" name="GNU" value="3" /> <b>Not Released</b> - You only authorise The HMCS to use and make neccessary edits to this tutorial.

What I want is the choice the user makes to be saved along with the tutorial and its title, etc.

When they click the edit button, the choice they made should show up again, and when a user views the tutorial, I want an if-conditional to make one of three images show depending on the choice the author made.

For those last two all I need to know what it would be in the if... like <if condition="$gnu=1"> sorta thing. If I know that I can make the templates.

You would have to add a column to the tutorial table, and then edit the query retrieving the information, and then you will need to display the information by editing the tutorial page accordingly.

(As I've never used this system, I have to be somewhat vague on it)

[Zowners]

I don't want to be messing around with the database unless I have an idea of how to do what I want to. (Command wise)

Nobody knows?.. Like I know I can open up mysql and type in something like create blah or delete blah... I just need to know what do do with that, and how to reference it in the tutorials templates using an if.

[Zowners]

Anyone?

[Zowners]

Would I also need to change the query for submitting the information?