Jump to content

Archived

This topic is now archived and is closed to further replies.

pelegk2

very strange problem with insert command

Recommended Posts

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??????

Share this post


Link to post
Share on other sites

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\' )"); 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.