|
|
Posted by Jerry Stuckle on 05/27/07 20:44
e_matthes@hotmail.com wrote:
> Hello,
>
> I am developing on a windows machine, and hosting on a linux server.
> I have written my php code using table names like siteStats and column
> names like userStatus. I have just realized the conflict this creates
> when uploading to the live server; table siteStats is not recognized,
> but table sitestats is recognized. The solution seems to be:
>
> 1 - change all table names (and other case-sensitive names) to an all-
> lowercase convention, i.e. siteStats => sitestats or site_stats;
> 2 - change table names on live version, in the database itself, to
> lowerUpper format.
>
> I really like using the lowerUpper format because I find it annoying
> to type underscores all the time, and lowerlower becomes hard to
> read. However, it is more important to me that my live and local
> scripts are identical.
>
> Does anyone else use the lowerUpper format successfully for things
> like mySql table names, when developing on windows and hosting on
> linux? Any suggestions? Thank you.
>
Either way works, as long as you are consistent. I use both (not at the
same time, typically), depending on the project. But I, too, prefer the
mixed case format - I find it easier to read. But some programmers
don't like it.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|