Re: [PHP-DEV] Re: mysql 4.0.6 gamma and php 4.3.0 .... ?
oh thanks, didn't notice its only related to windows. Thomas On Fri, 20 Dec 2002 22:52:51 +0100 (CET) [EMAIL PROTECTED] (Derick Rethans) wrote: On Fri, 20 Dec 2002, Thomas Seifert wrote: what's the exact problem with the php/mysql4-interaction? I'm using mysql-4.0.5 and php-4.2.3 in production without any problems. Ok, I'm not using any special features of mysql4 ;-). Nothing, just that the mysql extension in the Windows build is linked against the bundled mysql which is of version 3.23.53, and not to an external library with a version 4 library. Derick On Fri, 20 Dec 2002 21:28:44 - [EMAIL PROTECTED] (Tijn) wrote: I had a conversation with derick over email - here is a summary for those struggeling with the same issue: 4.3 will not include the new mysql client compatible with mysql 4 This will be included in php 4.4 / 5 4.4/5 will include an extension which is much more compatible with mysql 4 The current CVS of php 4.4 does not yet include this new extension Hope this helps others tijn -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php -- - Derick Rethans http://derickrethans.nl/ PHP Magazine - PHP Magazine for Professionals http://php-mag.net/ - -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Re: mysql 4.0.6 gamma and php 4.3.0 .... ?
The problem is related to both windows and linux - but on linux you can easily recompile and include the client that is included with mysql 4. On Windows you need Visual Studio / C++ to re-compile (as I understand itif anyone knows how to recompile php on windows using only opensource tools...please let me know.) tijn Thomas Seifert [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... oh thanks, didn't notice its only related to windows. Thomas On Fri, 20 Dec 2002 22:52:51 +0100 (CET) [EMAIL PROTECTED] (Derick Rethans) wrote: On Fri, 20 Dec 2002, Thomas Seifert wrote: what's the exact problem with the php/mysql4-interaction? I'm using mysql-4.0.5 and php-4.2.3 in production without any problems. Ok, I'm not using any special features of mysql4 ;-). Nothing, just that the mysql extension in the Windows build is linked against the bundled mysql which is of version 3.23.53, and not to an external library with a version 4 library. Derick On Fri, 20 Dec 2002 21:28:44 - [EMAIL PROTECTED] (Tijn) wrote: I had a conversation with derick over email - here is a summary for those struggeling with the same issue: 4.3 will not include the new mysql client compatible with mysql 4 This will be included in php 4.4 / 5 4.4/5 will include an extension which is much more compatible with mysql 4 The current CVS of php 4.4 does not yet include this new extension Hope this helps others tijn -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php -- - Derick Rethans http://derickrethans.nl/ PHP Magazine - PHP Magazine for Professionals http://php-mag.net/ - -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DEV] Re: mysql 4.0.6 gamma and php 4.3.0 .... ?
The exact problem is to do with sql SELECT queries from PHP that use 'LEFT JOIN' 'WHERE'. When using php (eg mysql_fetch_array()) to retrieve rows, normally you can use 2 methods to access the results in the myrow array: $result1 = $myrow[0]; #the numerical method $result2 = $myrow['proj_id']; #referring to the field name the latter method (result2), for some rows, is only returning NULL instead of the real value, which is returned by the $result1 method. The query is am referring to is the following: SELECT * FROM rs_projects AS p LEFT JOIN rs_proj_members AS m USING (proj_id) WHERE (p.create_id='3') OR (m.user_id='3' AND (m.rights '8' = 8)) When running this query from mysql directly there is no problem, so this indicates to me that the issue is related to the older version client included in php 4.3. Tijn Thomas Seifert [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... what's the exact problem with the php/mysql4-interaction? I'm using mysql-4.0.5 and php-4.2.3 in production without any problems. Ok, I'm not using any special features of mysql4 ;-). Regards, Thomas On Fri, 20 Dec 2002 21:28:44 - [EMAIL PROTECTED] (Tijn) wrote: I had a conversation with derick over email - here is a summary for those struggeling with the same issue: 4.3 will not include the new mysql client compatible with mysql 4 This will be included in php 4.4 / 5 4.4/5 will include an extension which is much more compatible with mysql 4 The current CVS of php 4.4 does not yet include this new extension Hope this helps others tijn -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Re: mysql 4.0.6 gamma and php 4.3.0 .... ?
ok - apologies. I just realised that it was actually to do with the table/field setup (fields with the same name in both tables) and the specific left join query. The sql statement used (left join) would select all columns from 2 tables, both of which included some similar fields (ie create_id and create_date). I did not realise that the$myrow array returned by php only includes one result for fields from 2 tables with the same name, and that it would overwrite the results from the first table with the second. Tijn Tijn [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... The problem is related to both windows and linux - but on linux you can easily recompile and include the client that is included with mysql 4. On Windows you need Visual Studio / C++ to re-compile (as I understand itif anyone knows how to recompile php on windows using only opensource tools...please let me know.) tijn Thomas Seifert [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... oh thanks, didn't notice its only related to windows. Thomas On Fri, 20 Dec 2002 22:52:51 +0100 (CET) [EMAIL PROTECTED] (Derick Rethans) wrote: On Fri, 20 Dec 2002, Thomas Seifert wrote: what's the exact problem with the php/mysql4-interaction? I'm using mysql-4.0.5 and php-4.2.3 in production without any problems. Ok, I'm not using any special features of mysql4 ;-). Nothing, just that the mysql extension in the Windows build is linked against the bundled mysql which is of version 3.23.53, and not to an external library with a version 4 library. Derick On Fri, 20 Dec 2002 21:28:44 - [EMAIL PROTECTED] (Tijn) wrote: I had a conversation with derick over email - here is a summary for those struggeling with the same issue: 4.3 will not include the new mysql client compatible with mysql 4 This will be included in php 4.4 / 5 4.4/5 will include an extension which is much more compatible with mysql 4 The current CVS of php 4.4 does not yet include this new extension Hope this helps others tijn -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php -- - Derick Rethans http://derickrethans.nl/ PHP Magazine - PHP Magazine for Professionals http://php-mag.net/ - -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DEV] Re: mysql 4.0.6 gamma and php 4.3.0 .... ?
I had a conversation with derick over email - here is a summary for those struggeling with the same issue: 4.3 will not include the new mysql client compatible with mysql 4 This will be included in php 4.4 / 5 4.4/5 will include an extension which is much more compatible with mysql 4 The current CVS of php 4.4 does not yet include this new extension Hope this helps others tijn -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DEV] Re: mysql 4.0.6 gamma and php 4.3.0 .... ?
what's the exact problem with the php/mysql4-interaction? I'm using mysql-4.0.5 and php-4.2.3 in production without any problems. Ok, I'm not using any special features of mysql4 ;-). Regards, Thomas On Fri, 20 Dec 2002 21:28:44 - [EMAIL PROTECTED] (Tijn) wrote: I had a conversation with derick over email - here is a summary for those struggeling with the same issue: 4.3 will not include the new mysql client compatible with mysql 4 This will be included in php 4.4 / 5 4.4/5 will include an extension which is much more compatible with mysql 4 The current CVS of php 4.4 does not yet include this new extension Hope this helps others tijn -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Re: mysql 4.0.6 gamma and php 4.3.0 .... ?
On Fri, 20 Dec 2002, Thomas Seifert wrote: what's the exact problem with the php/mysql4-interaction? I'm using mysql-4.0.5 and php-4.2.3 in production without any problems. Ok, I'm not using any special features of mysql4 ;-). Nothing, just that the mysql extension in the Windows build is linked against the bundled mysql which is of version 3.23.53, and not to an external library with a version 4 library. Derick On Fri, 20 Dec 2002 21:28:44 - [EMAIL PROTECTED] (Tijn) wrote: I had a conversation with derick over email - here is a summary for those struggeling with the same issue: 4.3 will not include the new mysql client compatible with mysql 4 This will be included in php 4.4 / 5 4.4/5 will include an extension which is much more compatible with mysql 4 The current CVS of php 4.4 does not yet include this new extension Hope this helps others tijn -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php -- - Derick Rethans http://derickrethans.nl/ PHP Magazine - PHP Magazine for Professionals http://php-mag.net/ - -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php