Jump to content

Archived

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

whizzykid

solving this.

Recommended Posts

My sql works when i use int data string  but i cant seem to be able to insert currency signs.

this is my code.

GetSQLValueString($_POST['Available_balance'], "int"),

Share this post


Link to post
Share on other sites

currency signs, if im not mistaken, should be added when the data is parsed, not stored in the database.

 

hopefully im on line with what you are asking.

Share this post


Link to post
Share on other sites

Thanks but no tht is not what i am asking,what is the data type for me to use,when i use int i cant insert currency signs.

Share this post


Link to post
Share on other sites

if you want to insert a $ along with a number, use varchar, although this is not the most efficient way to store money values.

Share this post


Link to post
Share on other sites

Yea i did use that but i am just confused as what to use as the input type.i use

 GetSQLValueString($_POST['Available_balance'], "int"),

Share this post


Link to post
Share on other sites

mssql has a money data type. and a smallmoney type if i remember correctly. use either one. when you are outputting the figure, output a currency symbol next to it. at least then you can still do math with the numbers.

Share this post


Link to post
Share on other sites

×
×
  • Create New...

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.