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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
