Need help working out something

I have a series of drop down menus such as:

Menu One:

• Select one please...
• Basketball
• Soccer
• Golf

Menu Two:

• Select one please...
• Basketball
• Soccer
• Golf

Menu Three:

• Select one please...
• Basketball
• Soccer
• Golf

And each of the three list items corresponds to a value (For examples say, 1pt, 2pt, 3pt respectively).

Now I've been trying to wrap my head around on the best way to have it so that if a person selects Soccer and Golf, it would then tally the total and submit it to the database. (Total being 5pts)
It also has to recognize when a field contains 'Select one please...' and count that as 0pts.

I've been trying to just do it with simple math functions in PHP, calling each sport's value when called then trying to add them but it gets mucked up when I have any of the 0pt selections.

Any suggestions on the best route to make such a tool?

Are your values "2pts" or is it "2"?

If it is the latter,
If you need any more help, feel free to add me on MSN.

Ah well ive just recently done something like this. Go to www.dynamicdrive.net.

http://dynamicdrive.com/dynamicindex...ects/index.htm

I think thats what your looking for.

Originally Posted by Xi0s Ah well ive just recently done something like this. Go to www.dynamicdrive.net. http://dynamicdrive.com/dynamicindex...ects/index.htm I think thats what your looking for.

Well, the way I posted and how he described doesn't need that fancy shmancy script.

It works good, now I just have to work in a verification script and for some reason the statement:

$selecteditem = $_POST['menu1'];
if (isset($_POST['menu1']) !== 0){
print $selecteditem;
}

Isn't working...I've tried putting 0 in a variable, putting all types of quotes around it.

Ye on reflection, i think andrews solution looks better .

The $_GET/POST items will always be strings, so a strict comparison check (!==) will always be false if you're checking against an integer. You can use type casting or the intval function.

Well here, I'll try to explain a bit more...
My database of 'sports' is setup as so:

ID, Name, Points.

1, Select one..., 0.
2, Golf, 1.
3, Soccer, 2.
4, Basketball, 3.

Now after the form is submitted I want it to show a UL of all the menus that have been selected, but I want the ones that have "Select one..." to be left out. So this is how I setup my menus:

<select name="1"> <? $result = mysql_query("select * from sports") or die(mysql_error()); while($row = mysql_fetch_array($result)){ print "<option value=\"".$row['id']."\">"; print $row['name']; print "</option>"; } ?> </select>

So the value of each menu is the ID from the database, which is where my If statement is coming into play, I want the If statement to rule out anything that has a value of 1 (that being the item in the database containing the name Select one...)

I've tried using < and > and all different operators and just can't figure it out.

<select name="1">
<?
$result = mysql_query("select * from sports") or die(mysql_error());
while($row = mysql_fetch_array($result)){
print "<option value=\"".$row['points']."\">";
print $row['name'];
print "</option>";
}
?>
</select>


then go for the code selected above.

Well, don't you want the value of each option to be the points? If so, change the value of the option to $row['points']. Also, an easier way is to have the Select one... not in the database.. here, give me a minute and I'll edit my post with a snippet.

Also with your code:
The isset() function either returns true or false, so you are basically saying does "true" equal 0 or not.

Hopefully you could figure that out. I THINK that's how you want it.