register with add jaden problem..

[d3core]

I have been tried many time to add in cubis@jaden in register page, all data has been insert into table cashnow but it wont insert to cashlog. If I use manual add jaden script, all data perfectly added into cahslog table.
I also has been use all register and add jade@cubis page, but all failed to add into cashlog, it stuck in cashnow only.
the code i use:
1) INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES ('$ID', '0', '$Sn', '0', '1', '$valcubisvx', '1', NOW())"))
2)MySQL_Query("call usecash ( '$id' , 1, 0, 1, 0, '$amount', 1, @error)");

this one is my manual script

$sql = "insert into usecashnow(userid, zoneid, sn, aid, point, cash, status, creatime) values ('$name', '1', '0', '1', '0', '$jaden', '1', '$date')";

 

[DNC]

I have been tried many time to add in cubis@jaden in register page, all data has been insert into table cashnow but it wont insert to cashlog. If I use manual add jaden script, all data perfectly added into cahslog table.
I also has been use all register and add jade@cubis page, but all failed to add into cashlog, it stuck in cashnow only.
the code i use:
1) INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES ('$ID', '0', '$Sn', '0', '1', '$valcubisvx', '1', NOW())"))
2)MySQL_Query("call usecash ( '$id' , 1, 0, 1, 0, '$amount', 1, @error)");

this one is my manual script

$sql = "insert into usecashnow(userid, zoneid, sn, aid, point, cash, status, creatime) values ('$name', '1', '0', '1', '0', '$jaden', '1', '$date')";

You show using NOW()??? But you need to use $date not NOW()