Why is this not working?

TrulyUnusualdotcom wrote:
> First off I am an extreme newbie and I'm following a book to do this. This
> is what to book calls for and I have searched all over for the proper syntax
> if this is incorrect with no luck.
>
> I'm using PHPMyAdmin to create this field in the pet table.
> ALTER TABLE `pet` ADD `price` DECIMAL( 9.2 ) NOT NULL
>
> I'm using MySQL 4.0.25 and phpMyAdmin 2.6.4-pl2
> I'm also using PHP 5 if that matters.
>
> here is what I get.
>
> SQL query:
> ALTER TABLE `pet` ADD `price` DECIMAL( 9.2 ) NOT NULL
> MySQL said:
> #1064 - You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> '9.2) NOT NULL' at line 1
>
> Just looking for the reasoning behind the error and what I'm missing. Maybe
> a good reference for minor syntax items like this would be good. I had a
> hell of a time finding anything related at phpmyadmin or php sites.
>
> Thanks in advance.
> Jaks
>
>

Jaks,

That should be (9,2) not (9.2). Comma separator instead of decimal point.

It's hard to tell the difference in the manual.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

TrulyUnusualdotcom wrote:
> Thanks for the help Jerry. You were dead on, in the book it sure looked
> like a period but after looking again sure enough it's a comma. I figured
> it out by comparing some queries for another script on phpfreaks. Thought I
> already posted that I found my answer. Sorry about that.
>
> Does anyone else find PHP.net and mysql.com hard to find what you need or is
> it just a newbie thing?
>
> Thanks again
> Jaks
> http://www.trulyunusual.com
>
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:wIWdnTUF9_NC2crZnZ2dnUVZ_sydnZ2d@comcast.com. ..
>
>>TrulyUnusualdotcom wrote:
>>
>>>First off I am an extreme newbie and I'm following a book to do this.
>>>This is what to book calls for and I have searched all over for the
>>>proper syntax if this is incorrect with no luck.
>>>
>>>I'm using PHPMyAdmin to create this field in the pet table.
>>>ALTER TABLE `pet` ADD `price` DECIMAL( 9.2 ) NOT NULL
>>>
>>>I'm using MySQL 4.0.25 and phpMyAdmin 2.6.4-pl2
>>>I'm also using PHP 5 if that matters.
>>>
>>>here is what I get.
>>>
>>>SQL query:
>>>ALTER TABLE `pet` ADD `price` DECIMAL( 9.2 ) NOT NULL
>>>MySQL said:
>>>#1064 - You have an error in your SQL syntax. Check the manual that
>>>corresponds to your MySQL server version for the right syntax to use near
>>>'9.2) NOT NULL' at line 1
>>>
>>>Just looking for the reasoning behind the error and what I'm missing.
>>>Maybe a good reference for minor syntax items like this would be good. I
>>>had a hell of a time finding anything related at phpmyadmin or php sites.
>>>
>>>Thanks in advance.
>>>Jaks
>>
>>Jaks,
>>
>>That should be (9,2) not (9.2). Comma separator instead of decimal point.
>>
>>It's hard to tell the difference in the manual.
>>
>>
>>--
>>==================
>>Remove the "x" from my email address
>>Jerry Stuckle
>>JDS Computer Training Corp.
>>jstucklex@attglobal.net
>>==================
>
>
>
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------
> http://www.usenet.com

NP, Jaks,

Several of my students have done that, also. It's quite easy to do, even if the
course materials are in larger type - and therefore the difference between a
comma and a period *should* be easier to spot :-).

I'm sure I had the same problem sometime, but unfortunately Babbage isn't still
around to verify that :-).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

TrulyUnusualdotcom wrote:
> Does anyone else find PHP.net and mysql.com hard to find what you
> need or is it just a newbie thing?


More or less a beginner here:

php.net => no, for an extreme newbee it might me worth reading through the
main function chapters (i.e. the short lists of functions) to get a basic
understanding of the possibilities. Also, when I started, the user comments
gave me a lot more clarity on how to use different functions. Searching the
online documentation works excellent for me, although sometimes refrasing
search terms is needed,.

mysql.com => yes, get a basic SQL book and it will help a lot more.

Grtz,
--
Rik Wasmus