solving this.

[whizzykid]

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"),

[abazoskib]

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.

[whizzykid]

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.

[abazoskib]

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

[whizzykid]

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"),

[abazoskib]

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.