using inner join when joined tables have common field name

[ts10]

 $getData = mysql_query("SELECT files.*,clients.* FROM files INNER JOIN clients ON files.clients_id = clients.id ORDER BY files.description ASC");
	  while($getDataArray = mysql_fetch_array($getData)) {
	  	echo("<a href=\"$PHP_SELF?go=delete&id=$getDataArray[id]\">DELETE</a> - " . $getDataArray[description] . " <i>[" . $getDataArray[username] . "]</i>" . "<br><br>");
	  }

$getDataArray[id] returns the id of the wrong table. How can I specify which table ID I want?

Thanks!

[mouloud2001]

use aliases :

 $getData = mysql_query("SELECT files.*,clients.*, files.id as files_id, clients.id as clients_id FROM files INNER JOIN clients ON files.clients_id = clients.id ORDER BY files.description ASC"); 
      while($getDataArray = mysql_fetch_array($getData)) { 
          echo("<a href=\"$PHP_SELF?go=delete&id=$getDataArray[files_id]\">DELETE</a> - " . $getDataArray[description] . " <i>[" . $getDataArray[username] . "]</i>" . "<br><br>"); 
      }  

[ts10]

Thanks a lot!