var char_id = 5; //we want the name of character number 5
str_for_num( strChar_id, char_id );
str_cpy( query, "SELECT name FROM characters WHERE char_id = " );
str_cat( query, strChar_id );

//do the mysql query with query string