Re: RE: [PHP-DB] looped insert

2001-10-24 Thread Mike Frazer
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'

[PHP-DB] Re: PHP & MySQL Queries...

2001-10-26 Thread Mike Frazer
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

[PHP-DB] Re: HTML Entities and $HTTP_POST_VARS

2001-10-31 Thread Mike Frazer
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

Re: [PHP-DB] PHP and MySQL queries...

2001-10-24 Thread Mike Frazer
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