[decongh]

Thanks for the help,my internet connection was bad hence my delay in getting back.

While away, i managed to solve it.But now it is not inserting at all. This is what i get when i run the code in mysql :

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

And this the code :

    if($navtype == "serxbh")
     
    {
     
    $com_name = $_POST['com_name'];
    $loc = $_POST['loc'];
    $name_mech = $_POST['name_mech'];
    $vtype = $_POST['vtype'];
    $s_veration = $_POST['s_veration'];
    $remnder_ver = $_POST['remnder_ver'];
    $vreg = $_POST['vreg'];
    $last_startdate = $_POST['last_startdate'];
    $mileage = $_POST['mileage'];
    $current_mileage = $_POST['current_mileage'];
    $cur_date = $_POST['cur_date'];
     
    $counter=0;
    $query = "select count(*) As counter FROM sre_log WHERE vreg = '$vreg'";
    $routes_result = mysql_query($query);
    $routes_num = 0;
    $routes_num = mysql_numrows($routes_result);
    $i = 0;
    //$x = 1
    while($i < $routes_num)
     
    {
    $counter = mysql_result($routes_result,$i,"counter");
     
    $i++;
    }
     
    if ($counter == 0 )
     
    {
     
     
    $sql = "insert INTO sre_log
    values('$com_name','$loc','$name_mech','$vtype','$s_veration','$remnder_ver','$vreg','$last_startdate','$mileage','$current_mileage','$cur_date')";
     
    }else{
     
    $sql = "UPDATE sre_log SET com_name='$com_name',loc='$loc',name_mech='$name_mech',vtype='$vtype',s_veration='$s_veration',remnder_ver='$remnder_ver',vreg='$vreg',last_startdate='$last_startdate',mileage='$mileage',current_mileage='$current_mileage',cur_date='$cur_date' WHERE vreg='$vreg'";
     
    mysql_query($sql);
     
     
    }

[Dormilich]

on line #38 you try to insert 11 values. according to the error message you have either more or less columns in that table.

This post has been edited by Dormilich: 12 January 2012 - 08:13 AM

[decongh]

i have specified the columns in my insert query and still it is not inserting.

    if($navtype == "serxbh")
     
    {
     
    $com_name = $_POST['com_name'];
    $loc = $_POST['loc'];
    $name_mech = $_POST['name_mech'];
    $vtype = $_POST['vtype'];
    $s_veration = $_POST['s_veration'];
    $remnder_ver = $_POST['remnder_ver'];
    $vreg = $_POST['vreg'];
    $last_startdate =$_POST['dy']."-".$_POST['dm']."-".$_POST['dd'];
    $mileage = $_POST['mileage'];
    $current_mileage = $_POST['current_mileage'];
    $cur_date = date("F j, Y, g:i a");
     
    $counter=0;
    $query = "select count(*) As counter FROM sre_log WHERE vreg = '$vreg'";
    $routes_result = mysql_query($query);
    $routes_num = 0;
    $routes_num = mysql_numrows($routes_result);
    $i = 0;
    //$x = 1
    while($i < $routes_num)
     
    {
    $counter = mysql_result($routes_result,$i,"counter");
     
    $i++;
    }
     
    if ($counter == 0 )
     
    {
     
     
    $sql = "insert INTO sre_log (com_name, loc, name_mech, vtype, s_veration, remnder_ver, vreg, last_startdate, mileage, current_mileage, cur_date)
    values('$com_name','$loc','$name_mech','$vtype','$s_veration','$remnder_ver','$vreg','$last_startdate','$mileage','$current_mileage','$cur_date')";
     
    }else{
     
    $sql = "UPDATE sre_log SET com_name='$com_name',loc='$loc',name_mech='$name_mech',vtype='$vtype',s_veration='$s_veration',remnder_ver='$remnder_ver',vreg='$vreg',last_startdate='$last_startdate',mileage='$mileage',current_mileage='$current_mileage',cur_date='$cur_date' WHERE vreg='$vreg'";
     
    mysql_query($sql);
     
    $sql = "UPDATE movlog SET mileage = '$mileage_in' WHERE vreg='$vreg'";
     
    mysql_query($sql);
     
    }

[decongh]

I have worked on the columns in that table and still,it's not inserting.

    if($navtype == "serxbh")
     
    {
     
    $com_name = $_POST['com_name'];
    $loc = $_POST['loc'];
    $name_mech = $_POST['name_mech'];
    $vtype = $_POST['vtype'];
    $s_veration = $_POST['s_veration'];
    $remnder_ver = $_POST['remnder_ver'];
    $vreg = $_POST['vreg'];
    $last_startdate =$_POST['dy']."-".$_POST['dm']."-".$_POST['dd'];
    $mileage = $_POST['mileage'];
    $current_mileage = $_POST['current_mileage'];
    $cur_date = date("F j, Y, g:i a");
     
    $counter=0;
    $query = "select count(*) As counter FROM sre_log WHERE vreg = '$vreg'";
    $routes_result = mysql_query($query);
    $routes_num = 0;
    $routes_num = mysql_numrows($routes_result);
    $i = 0;
    //$x = 1
    while($i < $routes_num)
     
    {
    $counter = mysql_result($routes_result,$i,"counter");
     
    $i++;
    }
     
    if ($counter == 0 )
     
    {
     
     
    $sql = "insert INTO sre_log (com_name, loc, name_mech, vtype, s_veration, remnder_ver, vreg, last_startdate, mileage, current_mileage, cur_date)
    values('$com_name','$loc','$name_mech','$vtype','$s_veration','$remnder_ver','$vreg','$last_startdate','$mileage','$current_mileage','$cur_date')";
     
    }else{
     
    $sql = "UPDATE sre_log SET com_name='$com_name',loc='$loc',name_mech='$name_mech',vtype='$vtype',s_veration='$s_veration',remnder_ver='$remnder_ver',vreg='$vreg',last_startdate='$last_startdate',mileage='$mileage',current_mileage='$current_mileage',cur_date='$cur_date' WHERE vreg='$vreg'";
     
    mysql_query($sql);
     
    $sql = "UPDATE movlog SET mileage = '$mileage_in' WHERE vreg='$vreg'";
     
    mysql_query($sql);
     
    }

[Dormilich]

have you verified which SQL is executed and if the execution is successful?