[PHP-DB] Where does the mysqli extension find the default connection charset?

2007-05-02 Thread Jean-Noël Rivasseau
Hello there, I'd like to know which configuration file or setting is used by PHP mysqli extension to know the default charset connection to the database. I have two boxes with MySQL 5 / PHP 5 on them. One is a Gentoo box, and on this one by default the connection happens in UTF-8. The other ser

Re: [PHP-DB] Where does the mysqli extension find the default connection charset?

2007-05-02 Thread Georg Richter
Jean-Noël Rivasseau wrote: > Hello there, > > I'd like to know which configuration file or setting is used by PHP mysqli > extension to know the default charset connection to the database. mysqli (and also mysql) extension uses the default character set for libmysql This can be package dependend

Re: [PHP-DB] PHP and MYSQL

2007-05-02 Thread James Gadrow
Chris wrote: Na Derro Cartwright wrote: I am currently running php4 with mysql 5. when I try to run a query using the mysql command I recieve and error that reads the resource id and a number. What does that mean? Firstly always cc the list - others will be able to provide their input and

[PHP-DB] DB Design Concepts

2007-05-02 Thread Max Thayer
I'm using MySQL 5.x InnoDB engine, transactional tables. I have a conceptual design question. If I have a two columns 'a' and 'b', a is the primary key, and b is a type double, in table 1 (T1) for which column b will have many NULL values, do I leave it with an allow null constraint on the column

Re: [PHP-DB] DB Design Concepts

2007-05-02 Thread Dan Shirah
Max, I am assuming that since column b will only be populated 7% of the time that it is not a value specific column (does not matter if it has a value or not) Therefore I would suggest leaving the NULL's in there as it will not (at least should not) affect any system performance. On 5/2/07, Ma

[PHP-DB] Re: [css-d] IE5.5 and td[scope]

2007-05-02 Thread James Gadrow
D. D. Brierton wrote: On Wed, 2007-05-02 at 16:24 +0100, Martin Paton wrote: I'm using ... #contactform table td[scope] {width:50%} ... to set the width of the label column of a form. Does IE 5.5 support this because I can't get it to pick up (or is there a workaround?) No, IE5.x

RE: [PHP-DB] DB Design Concepts

2007-05-02 Thread Max Thayer
That's one of the kickers. The 7% of the time the column is populated is determined by business logic. And when the business logic says it's needed, at application run time if certain conditions were met, the column takes on the characteristic NOT NULL attribute. -Original Message- From

Re: [PHP-DB] DB Design Concepts

2007-05-02 Thread Dan Shirah
Okay, so couldn't you just set a default value for the column (N for NULL). This way column 1 and column 2 both contain valid data for whichever state your column takes on. Then just tell your logic to omit the results of column 2 that have a value of "N". This way only your valid rows would be p

Re: [PHP-DB] DB Design Concepts

2007-05-02 Thread Chris
Max Thayer wrote: I'm using MySQL 5.x InnoDB engine, transactional tables. I have a conceptual design question. If I have a two columns 'a' and 'b', a is the primary key, and b is a type double, in table 1 (T1) for which column b will have many NULL values, do I leave it with an allow null cons

Re: [PHP-DB] DB Design Concepts

2007-05-02 Thread bedul
actualy i'm not soo smart.. > Max Thayer wrote: > > I'm using MySQL 5.x InnoDB engine, transactional tables. I have a > > conceptual design question. If I have a two columns 'a' and 'b', a is > > the primary key, and b is a type double, in table 1 (T1) for which > > column b will have many NULL v