Database column names.

From: Lee Osborne <osbornelee_at_hotmail.com>
Date: Thu, 10 May 2001 09:37:51 +0100
Message-ID: <989483933.7511.0.nnrp-14.c2de1f0e@news.demon.co.uk>

Hi all,

I am using MySQL for web database backends. This invariable involves pulling the data from the tables and displaying on web browser forms and such like.

I know that I can't use spaces in my column names. What is the standard way of naming colums bearing in mind the conversion on the name to a displayable format in the web browser eg.

NAMING CONVENTION 1.

SQL column:

. your_full_name

On-screen display:

. Your full name

HTML: . Your full name: <input name="your_full_name" value="$your_full_name">

NAMING CONVENTION 2

SQL column:

. yourFullName

On-screen display:

. Your Full Name

HTML:
. Your full name: <input name="yourFullName" value="$yourFullName">

I personally prefer the second convention for readability and efficiency. Converting either convention to on-screen display is very each.

I want to make my programs as portable and platform independant as possible.

Any thoughts?

Thanks,

Lee. Received on Thu May 10 2001 - 03:37:51 CDT