resize image stored in mysql and display and cut apart of it

[L_T_]

i succeeded in uploading images to mysql and display it from mysql,

but i want to know how resize the image got from mysql

                           how cut apart of the image got from mysql!

thanks for any response!