Status Variable

[La_Parka]

I want to make a minor PHP script that would track rebates I mail and send out, just as a small project, and I want to know how I would make a variable that would change the status between "In the mail" and "Received". Not like an open-ended text field but more like a drop-down box with those 2 as the only options. Thanks

[daynah]

Hi La Parka,

I think you just answered yourself. 🙂 But what you would do is create a form that would submit the data into a database. Have a field called 'status.' When the value is 0, that means the rebate hasn't been received. And when it is 1, that means you recieve it.

So a sample form would look like this:

<form action="myform.php" method="post">
<input type="text" name="rebatename">
<input type="text" name="datesent">
<select name="status">
<option value="0">In The Mail</option>
<option value="1">Received</option>
</select>
<input type="submit" name="sendrebate" value="Send Rebate Data">
</form>

When you submit this data, send it to a database. And then for the other half of your project, you can write an interface to update the database. That way, when you receive your rebates, you can go ahead and update it also. 🙂

[La_Parka]

Actually I want to administer the DB strictly through phpmyadmin, and not via form, so I would like to create a field for sent/received status in the MySQL table through it (phpmyadmin.)

On a somewhat related note, how would I create a field to indicate date in MySQL? Would I use a plain TEXT field, or is there some other syntax I should use when I create the table?

Thanks for the help thus far