[SOLVED] Radio buttons value - MySQL

[dont_be_hasty]

Ok, so my webpage has 4 radio button they are:

 

<input type="radio" name="id" value="???" checked> All
<input type="radio" name="id" value="1"> 1
<input type="radio" name="id" value="2"> 2
<input type="radio" name="id" value="3"> 3

 

I then have a mysql query where i use the value selected from the radio box. But i need to know what value to i need put in the 'All' radio button (where the ? ? ? are) so that it can return results of any id (not just 1 or just 2, but can return 1, 2 and 3 altogether)

 

Thanks

[sc_84]

You could set the value to "All" then run a different query based on which radio buttion is checked for example:

 

if($id == "All"){ $query = "SELECT * from Table"; }

 

else { $query = "SELECT * from Table where id = '$id'; }

[dont_be_hasty]

Worked perfectly

 

Thank you!