[SOLVED] grab first 2 numbers from a field and put into new field?

[polardude1983]

I have a current_weight field. where ppl have their weight put in there so. if someone enters their weight in the form i have as 228 then the current_weight field says 228

 

and that works. but what i want is for it to grab the first 2 numbers from current_weight and put it into a field called new_weight.

 

so if someone puts 228 in current_weight, new_weight is 22

if someone puts 180 in current_weight, new_weight is 18

 

any idea on how to do this? im very puzzled

[dreamwest]

If your only dealing with 3 numbers

 

`new_weight` CHAR(2),

 

That will truncate the last number

[polardude1983]

I come up with an error.

 

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHAR(2)

 

mysql_query ( "INSERT INTO members (`username`, `password`, `start_weight_big CHAR(2)`, start_weight_dec) VALUES ('$username', '$password', '$start_weight_big', $start_weight_dec)" );

 

this is in the php file. I have the html file which gets the user input then calls the php file to input in the database.

 

 

[polardude1983]

sorry i mean it was this way and it didn't work.

 

mysql_query ( "INSERT INTO members (`username`, `password`, `start_weight_big` CHAR(2), start_weight_dec) VALUES ('$username', '$password', '$start_weight_big', $start_weight_dec)" );

[polardude1983]

never mind stupid me.. lol i got it thx sooo much