Re: My Project

Matt Darby wrote:

It *is* a great book (I cut my teeth with it as well): PHP and MySQL Development (Welling and Thomson) http://www.amazon.com/exec/obidos/tg/detail/-/0672326728/qid=1121869940/sr=8-1/ref=pd_bbs_1/002-5827183-4477639?v=glance&s=books&n=507846 Read it, learn it, live it. Matt Darby Jay Blanchard wrote:

[snip]

Hey, Look I made a new database just for this money testing stuff. This is the table: CREATE TABLE money ( money varchar(255) NOT NULL default '' ) TYPE=MyISAM; Now, I use this code $sqlUpdate = "UPDATE myDatabase.myTable SET myMoney = (myMoney-10) WHERE myCharacter = characterName "; $doUpdate = mysql_query($sqlUpdate, $myConnection); And it should work, And it gives no error but it is not writing anything into the database.

[/snip] Anyone else want to go for shorter? :) The reason is George, as someone so aptly pointed out, it appears that you have jumped in without any basic knowledge. And thus far we have all been nice (because we usually get chided for our terseness). So let me be the first to say RTFM, STFW and STFA and get a better book such as PHP and MySQL Development (Welling and Thomson) or one of a dozen others. Google for PHP tutorials. Read them, try them, learn them. Now let me explain where you went wrong above.... Your table needs two columns, one for money and one for characterName. Make money decimal(8,2) and characterName char(64) then do the following query INSERT INTO money (money, characterName) VALUES ('100.00', 'Village_Id10t'); Now do a select from the table to see the values entered. See them? Good! Now perform the following query; $sqlUpdate = "UPDATE money SET money = (money-10) WHERE characterName = Village_Id10t "; $doUpdate = mysql_query($sqlUpdate, $myConnection); Now do a select again and look at the values, did it work? Excellent! Run this query; $sqlUpdate = "UPDATE money SET money = (money-10) WHERE characterName = Town_Drunk "; $doUpdate = mysql_query($sqlUpdate, $myConnection); Now do a select from the table and note that the value of money did not change. The reason is because there is no Town_Drunk in the money table. Does that make sense? Wonderful!

Honestly, the best "book" I read when I was starting out, and one I've been using ever since, is the manual. I actually spent $ on a very good php book but I think I've only cracked the cover on it once or twice in two years. Way to go manual guys! :D