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 -0000 [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
