Table Size Recommendation(s)??

Is there a recommended size (# of columns) to a given database table?

I'm really just curious, I understand the
concept of normalization and the one to many scenario.

But, in some cases.. is it just a good idea to split a table into multiple tables, after so many columns?

Last question--

HTML in a database table.. should HTML be encoded? Granted, I've inserted URL's without a problem, and I've noticed that "'" single quotes need be processed with the before it... I'm just wondering about other
HTML related character's that may present problems?

------------------
SnR Graphics,
Low Cost Hosting and Web Development.

There is no recommended set number of columns in a table, just whatever is needed to describe your data.
It could be as simple as a few or as many as a couple of dozen.
You should look into the welath of internet articles on database design.

Group related sets of data into individual tables, with a common column so they can be related.

html code is plain text. It depends on the special characters you need to escape with the escape character such as backslant. You can specifically which ones and how to handlw them at the following link: http://www.mysql.com/documentation/...e.html#Literals

the part you want reads as follows:
Within a string, certain sequences have special meaning. Each of these sequences begins with a
backslash (`'), known as the escape character. MySQL recognizes the following escape
sequences:

An ASCII 0 (NUL) character.
n A newline character.
t A tab character.
r A carriage return character.
b A backspace character.
' A single quote (`'') character.
" A double quote (`"') character.
A backslash (`') character.
% A `%' character. This is used to search for literal instances of `%' in contexts where `%'
would otherwise be interpreted as a wildcard character. See section 7.4.6 String comparison
functions.
_ A `_' character. This is used to search for literal instances of `_' in contexts where `_'
would otherwise be interpreted as a wildcard character. See section 7.4.6 String comparison
functions.

------------------