Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    26

    Unanswered: very strange problem with insert command

    i am working php+mySql
    i am trying to do a simple insert command :
    $query2="INSERT INTO tblPrint (OrderNum,PrinterNum,DateTimeVal) Values('$order_num','$radio','$tmpDateTimeVal')";

    when i havethis values :
    $order_num=313.517;
    $radio=1;
    $tmpDateTimeVal=date("Y-m-d H:i:s");

    when i check the mysql i see that the order_num value
    is for some reason 3.517 ?!?!?!?!?!
    why is that?any idea????
    the more intresting if i do the same line with the same values it tels me its a duplicate key!!!!!!
    but if i chek it from php with a select it tells m that that vakue dosent exist!!!!!!!!
    help dont know what else to do!

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: very strange problem with insert command

    Originally posted by pelegk2
    i am working php+mySql
    i am trying to do a simple insert command :
    $query2="INSERT INTO tblPrint (OrderNum,PrinterNum,DateTimeVal) Values('$order_num','$radio','$tmpDateTimeVal')";

    when i havethis values :
    $order_num=313.517;
    $radio=1;
    $tmpDateTimeVal=date("Y-m-d H:i:s");

    when i check the mysql i see that the order_num value
    is for some reason 3.517 ?!?!?!?!?!
    why is that?any idea????
    the more intresting if i do the same line with the same values it tels me its a duplicate key!!!!!!
    but if i chek it from php with a select it tells m that that vakue dosent exist!!!!!!!!
    help dont know what else to do!
    Check the SQL which was creted the table. Possible you was wrong with column order_num

  3. #3
    Join Date
    Oct 2003
    Posts
    13
    i am working php+mySql
    i am trying to do a simple insert command :
    $query2="INSERT INTO tblPrint (OrderNum,PrinterNum,DateTimeVal) Values('$order_num','$radio','$tmpDateTimeVal')";

    when i havethis values :
    $order_num=313.517;
    $radio=1;
    $tmpDateTimeVal=date("Y-m-d H:i:s");

    when i check the mysql i see that the order_num value
    is for some reason 3.517 ?!?!?!?!?!
    why is that?any idea????
    the more intresting if i do the same line with the same values it tels me its a duplicate key!!!!!!
    but if i chek it from php with a select it tells m that that vakue dosent exist!!!!!!!!
    help dont know what else to do!
    -----------------------------------------------------------------------------------------------------------------

    first thing try to number_format the $order_num http://au.php.net/manual/en/function.number-format.php

    secondly check in mysql what is the datatype of the field if its float , and try to increase the digits like ( float(7,3)

    and please explain with some more code


    thanks
    Manish Khanna
    manish@i4u.com.au

  4. #4
    Join Date
    Nov 2003
    Posts
    26

    ok i have found the problem

    i was reciving from ERP (its like SAP)
    unvisible chars that did all the messs
    thanks for r all the help
    peleg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •