开发者

Why doesn't my query work?

It checks out with no errors, but does nothing to my database.

Heres my query:

mysql_query("INSERT INTO dc_donations (transaction_id,amount,original_request) VALUES (".$randomID.",".(float)$_POST['a开发者_如何学Cmount'].",'demo donation')");

Also, a query below it works perfectly.. So connection is fine.


Is this PHP?

mysql_query("INSERT INTO dc_donations (transaction_id,amount,original_request) VALUES (".$randomID.",".(float)$_POST['amount'].",'demo donation')");

I'd recommend not inserting from the post, but have you tried

echo mysql_error();

? that should be enlightening.


What is the type of your variables? I presume it's int, float and char(n), respectively? Try removing the (float), because it's not necessary in PHP. Also, go with @genesis's suggestion of adding "or die(mysql_error())".

On a side note, make sure you properly escape the $_POST variables.


Try replace your code with (it will give you answer)

mysql_query("INSERT INTO dc_donations (transaction_id,amount,original_request) VALUES (".$randomID.",".(float)$_POST['amount'].",'demo donation')") or die(mysql_error());
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜