the problem starts with the insert
the values are inserted but
when i on the mysql do a select i got an empty line!!!!!!!!!
why can that be?
this is my insert
<?php
$query2="INSERT INTO tblPrint ('OrderNum','PrinterNum','DateTime') Values('$orderN','$radio','2003-12-15 10:25:33')";
$result2 = mysql_query ($query2) or die ($query2);
?>
this is the problem :
when i do this :
$query1="select OrderNum from tblPrint where OrderNum='$orderN'";
$result1 = mysql_query ($query1) or die ($query1);
$tmpDateTimeVal=date("Y-m-d H:i:s");
if (mysql_affected_rows()){ // the order already in DB
//echo "in table";
$query2="UPDATE tblPrint set PrinterNum='$radio',DateTimeVal='$tmpDateTimeVal' where OrderNum='$orderN'";
$result2 = mysql_query ($query2) or die (mysql_error());
}else{ // need to write the order for the first time
//echo "not in table";
$query2="INSERT INTO tblPrint (OrderNum,PrinterNum,DateTimeVal) Values('$orderN','$radio','$tmpDateTimeVal')";
$result2 = mysql_query ($query2) or die (mysql_error());
}
and $orderN=313.34 and $radio=1
and then i check the mysql
i see this line :
31.34 1 2003-12-15 14:38:39
first it cuts!!!!!!! the number i dont know why!
and secondly when on mysql oi do a select on
"31.34" as show or on "313.34" i get that there are no records although i see them with my own eyes!!!!!!!!!
what is going on?
i see