[mySQL] aiuto

[iz8eej]

qualcuno mi aiuterebbe a capire da cosa può essere generato questo errore:

mySQL query error: SELECT m.name, m.id, m.posts, m.joined, m.mgroup, m.email,m.title, m.hide_email, m.location, m.aim_name, m.icq_number,
     me.photo_location, me.photo_type, me.photo_dimensions, field_1
        FROM ibf_members m, ibf_pfields_content
          LEFT JOIN ibf_member_extra me ON me.id=m.id
          LEFT JOIN ibf_groups g ON m.mgroup=g.g_id
        WHERE m.id=member_id AND g.g_hide_from_list <> 1
        ORDER BY m.name asc
        LIMIT 0,10

mySQL error: Unknown column 'm.id' in 'on clause'
mySQL error code: 
Date: Thursday 23rd of March 2006 08:17:11 PM

grazie a tutti

[iz8eej]

ho risolto grazie comunque.

si trattava di un problam di sintassi nella query dovuta a mysql5:

da

FROM ibf_members m, ibf_pfields_content

a

FROM (ibf_members m, ibf_pfields_content)