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
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']; #
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...p
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 i
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 l
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
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 C