Using the word "change" in php...

[Peschtra]

Hello --

Perhaps this is a silly question, but is the word "change" a php or
MySql command? I had a script that wouldn't work with the a field called
"change" in it, but when I removed that field it worked fine.

Just wondering.

Thanks,

Peter

[lorento]

Re: Using the word "change&qu ot; in php...

Yes you can't use "change" word as table name because its a reserved
word. You can see the mysql manual whats are reserved words. Some of
reserved words are: change, anaylze, convert, connection, cascade,
schema, natural, spesific, etc..

regards,

Lorento
--

http://www.mastervb.net

http://www.padbuilder.com , http://www.immersivelounge.com

[Iván Sánchez Ortega]

Re: Using the word "change&qu ot; in php...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Peschtra wrote:
[color=blue]
> Perhaps this is a silly question, but is the word "change" a php or
> MySql command?[/color]

It is a MySQL reserved word. Recommended reading:
http://dev.mysql.com/doc/refman/5.0/...ved-words.html

http://php.net/manual/en/reserved.php

- --
- ----------------------------------
Iván Sánchez Ortega -i-punto-sanchez--arroba-mirame-punto-net

http://acm.asoc.fi.upm.es/~mr/

Proudly running Debian Linux with 2.6.15-1-686 kernel, KDE3.5.0, and PHP
5.1.2-1+b1 generating this signature.
Uptime: 11:53:43 up 19:03, 1 user, load average: 1.25, 0.49, 0.22

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)

iD8DBQFEfrmi3jc Q2mg3Pc8RAt6mAJ 9GvS5qyr0zBKWko JePJ54kfDV4pQCf Sh4H
rmgA+e6xPm9ymly vddHzkKE=
=Exg+
-----END PGP SIGNATURE-----