g:
INSERT INTO table VALUES ('value1', 'value2', NULL, 'value3');
INSERT INTO table VALUES ('value1', 'value2', , 'value3');
NOTE: I didn't read the entire post below...it's too early in the morning to
think about code. I'
ing this format allows you to print only what is necessary. At the same
time, if you had more results than you had spaces to print them, your
results would have been truncated.
If you want to be able to search multiple columns in your DB, you can for
your query as:
SELECT * FROM table WHERE (column
Try replacing the values before you dump it into the database:
$value = str_replace("#0169", "©", $value);
Do that for all the values. You can make it do the reverse when you need to
display the values in HTML (although most browsers after Netscape v2.x and
IE v3.x recognize these characters wi
f 10242001
will take you 2-4 bytes depending on the type of int you declare. Not a lot
of space, but assume for a second you have 30 fields in your database and 5
million rows...suddenly those 6-8 bytes have multiplied on this one field
alone. Space and speed are important in DBs :)
Mike Frazer