I have 2 tables:
[table1]
  BLOCK_ID mediumint(8)
  SUB_ID mediumint(8)
  ...
[table2]
  BLOCK_ID mediumint(8)
  ...
I call query:
  SELECT * FROM table1 a, table2 b
  WHERE a.sub_id=b.block_id AND a.block_id=1;
It works well.
But when I use same query without aliases:
  SELECT * FROM table1, table2
  WHERE table1.sub_id=table2.block_id AND a.block_id=1;
In this case mysql_fetch_assoc() returns only 1 field BLOCK_ID and it's table2.BLOCK_ID.
I think it's a bug in mysql_fetch_assoc() because MysqlFront returns table1.BLOCK_ID as BLOCK_ID and table2.BLOCK_ID as BLOCK_ID_1

Thank you.