This is strange. It won't insert "0" option value into table.

[imgrooot]

I am finding that if I have "0"(zero) value in form select option, it won't select this option or submit data.  If I change this value to any other number to text, it will work.  Is there a way to fix this?  I have to have an option where I am able to choose to submit "0" value to the database table.

<option value="0" <?php if(empty($_POST['special'])) {} else { if($_POST['special'] == 0) { echo 'selected'; } } ?> >None</option>

[Barand]

that's because zero is considered to be "empty"

 

eg

$a = 0;
if (empty($a)) echo 'ok';  //--> ok

[imgrooot]

 

that's because zero is considered to be "empty"

 

eg

$a = 0;
if (empty($a)) echo 'ok';  //--> ok

 

So what's the solution? The column I am inserting into is "int" based. So I need an int number to distinguish from all the other numbers.  Is there no way to add zero to it?

[imgrooot]

The only other solution I can think of is to turn the table into "varchar" and use a unique text like "none" to replace "0".

[Barand]

All you have shown us is a single line of incorrect code and I pointed out what is wrong with that code.

 

You could try

<option value="0" <?php  if ($_POST['special'] === '0') echo 'selected';  ?> >None</option>

On the basis of a single line I can not and will not comment on an application solution, as I have no idea what the significance of the "0" versus "" is in the overall context. But your proposed alternative sounds wrong.

[techboy992]

Hi

 

The only other solution I can think of is to turn the table into "varchar" and use a unique text like "none" to replace "0".

 

You could direct set it to 0 in the database using the default option and choose as defined =0 if it's a empty value it will set it to 0