[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

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 enabled/c

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 anyw

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 some

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.

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 cann

Re: [PHP-DB] PHP cannot access mySQL

2007-11-02 Thread Nhan
I can retrieve no errormessage. PHP script ran to the line, where connection to MySQL is build. I think, I must setup the IIS so, that it error message is displayed (???). With the following code is shown only the string "before connecting". How can I do? My PHP code: echo "before connecting";