Jiraiya Posted November 17, 2008 Share Posted November 17, 2008 SELECT - Take out out of the database UPDATE - Update an existing column ALTER - Change something in the database (Add to or something) Quote Link to comment Share on other sites More sharing options...
Lodius2000 Posted November 17, 2008 Share Posted November 17, 2008 gotta be more specific there are countless ways to use select, update is a bit more narrow in its variations and alter, to me is for changing the structure of tables, least thats how I use it do you have phpmyadmin, if so use it and see what the sql it uses looks like, anytime you change anything it prints out the sql it used when the page reloads Quote Link to comment Share on other sites More sharing options...
Jiraiya Posted November 17, 2008 Author Share Posted November 17, 2008 i want a to have a fighting like system in the game i am making. like in the mysql table there are npc enemys for players to fight against to train there characters. the npc enemys have preset health Skill(what is used to determine strength basically its just subtracting the skill from the enemys health and keep doing that until the one of them dies by having there health reach zero. and when a player kills a npc enemy i want the player to gain a set amount of "skill" points and cash to add to there character profiles any idea were i should start? Quote Link to comment Share on other sites More sharing options...
Lodius2000 Posted November 17, 2008 Share Posted November 17, 2008 im out, I dont do games, nothing against them, just not for me Quote Link to comment Share on other sites More sharing options...
corbin Posted November 17, 2008 Share Posted November 17, 2008 Learn PHP and MySQL and come back when you can show you've actually tried. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.