Re: [PHP-DB] PHP and MySQL design question

2007-11-02 Thread Chris
Roberto Mansfield wrote: It shouldn't matter what order the columns are referenced. Mysql is smart enough to optimize the query based on the available indexes. In some cases yes but as with anything there are exceptions :) mysql (and every other db) gets it wrong sometimes. In fact, it

Re: [PHP-DB] PHP cannot access mySQL

2007-11-02 Thread Nhan
OK, now I have the errormessage: Fatal error: Call to undefined function mysql_connect() Why? Chris [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nhan wrote: Hi, I have IIS 5.1 with PHP 5 and MySQL 4.1 With a client tool (such as MySQL Front) I can access MySQL. But my PHP

Re: [PHP-DB] PHP cannot access mySQL

2007-11-02 Thread Nhan
which cmmand tell PHP, that the script may ignore error and run further.? Chris [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nhan wrote: Hi, I have IIS 5.1 with PHP 5 and MySQL 4.1 With a client tool (such as MySQL Front) I can access MySQL. But my PHP page cannot, with the

Re: [PHP-DB] PHP and MySQL design question

2007-11-02 Thread Roberto Mansfield
Chris wrote: Mysql will actually only use one index per table. I was surprised to find this out but it's mentioned in http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/dp/0596003064/ - page 64 (just looked it up to include a page ref). No idea if this is mentioned anywhere on the

Re: [PHP-DB] PHP and MySQL design question

2007-11-02 Thread robertom
Chris wrote: Roberto Mansfield wrote: It shouldn't matter what order the columns are referenced. Mysql is smart enough to optimize the query based on the available indexes. In some cases yes but as with anything there are exceptions :) mysql (and every other db) gets it wrong sometimes.

Re: [PHP-DB] PHP cannot access mySQL

2007-11-02 Thread niccguard-dev
Is Mysql configured in PHP to be usable? Just having both installed isn't enough, there is configuration to 'enable' mysql. Try this link: http://www.php.net/manual/en/ref.mysql.php Based on the fact that it is saying mysql_connect() is undefined, I'd say that mysql functions aren't

[PHP-DB] Mail from GioMBG adventure in a while cycle of a donkey with php and sql

2007-11-02 Thread Gio MBG Canepa root
Hi All! This is to write wiki code and insert near some dinamic link some names of tracks, the dinamic link is generated but I don't know the way to change the var $TITOLO1 to $TITOLO2 for retrive the next records I have in database: TITOLO1 Pippo1 TITOLO2 Pippo2 TITOLO3 Pippo3 TITOLO4