Jump to content


Photo

very strange problem with insert command


  • Please log in to reply
2 replies to this topic

#1 pelegk2

pelegk2
  • Members
  • PipPip
  • Member
  • 11 posts
  • LocationIsrael

Posted 16 December 2003 - 06:50 AM

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!

after i did al of tht i did :

i changed the varchar to size 11
it at last put the data but when i do :
select * from tblprint where ordernum like \'%313.1729%\'

bu i get 0 records!!!why??????


Israel the best place to live in fter Heaven

#2 Influx

Influx
  • Members
  • Pip
  • Newbie
  • 2 posts
  • LocationCanada

Posted 22 December 2003 - 05:18 AM

Try this...

If this is part of your script add it here...
$order_num=313.517; $radio=1; $tmpDateTimeVal=date("Y-m-d H:i:s");$query2 = mysql_query("INSERT INTO tblPrint (OrderNum, PrinterNum, DateTimeVal) Values (\'$order_num\',\' $radio\', \'$tmpDateTimeVal\' )");

If it isn't broken or works, why fix it?

#3 pelegk2

pelegk2
  • Members
  • PipPip
  • Member
  • 11 posts
  • LocationIsrael

Posted 22 December 2003 - 06:35 AM

:)
Israel the best place to live in fter Heaven




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users