Q:

How to Insert time format in MySQL

I have form html  like this:
<html>
    <head>
    <body>
        <form action='upload_data.php' method="POST" enctype="multipart/form-data">
            <input type="text" name="total_container">
            <button id="submit">Add</button>    
        </form>
    </body>
    </head>
</html>

upload_data.php
include 'connect.php';
$total_container = $_POST["total_container"];

if (!empty($total_container)){
    $fill="INSERT INTO `container`(`total_container`, `time`)VALUES($total_container,'blabla')";
    $data=mysql_query($fill);
    if(isset($data)){
        echo "<script>alert ('Great');</script>";
    } else {
        echo "<script>alert('No...');</script>";
    }
}

I want to fill my database table (container) like this:
id_block  | total_container | time     |
---------------------------------------
1         | 1               | 00:00:20 |
2         | 2               | 00:00:40 |
3         | 3               | 00:01:00 |
4         | 6               | 00:02:00 |

id_block is auto_increment
for every total_container, its multiplied with 20 seconds in time field.

so, what should I do in my Query?, I want to fill time field automatically, multiplied with 20 seconds.

A:

try this 
INSERT INTO `container`(`total_container`, `time`) 
VALUES($total_container, SEC_TO_TIME($total_container*20) ) 

See reference for SEC_TO_TIME 

