thank you Killer_Typo
now i want to now how i can make update
should be around the same as what i said before, but use the UPDATE syntax. if you open up the mysql manual and do a search by going to edit, find on page. and type in the word you will most likely find all of the information you need to know about correct mysql syntax.
also i forgot to to mention that in the code that i listed above i forgot to add the line for selecting the correct databse. wich would be
$use = "USE database";
mysql_query($use) or die(mysql_error());
somthing along those lines should select the databse for the table you wish to modify (ive been writing my own custom database management tool, so ive been trying to get good with mysql syntax)