Dear Coders,
Iam facing a problem...
I have 3 tables files,platforms,resolutions in my database
Resolutions
Platforms
The table resolutions,platforms may have same file_id.. My aim is to select all the fields from files table using the file_id retrived from resoulutions,platforms table.
files must be displayed as distinct because the table platforms,resolutions may retrieve same file_id so it cause to display the files more than one time.
I want to display files from files table using the file_id
My Current Query (Its not working)
$match_resolution = '240x320';
$match_platform = 'Java MIDP 2.1';
SELECT * FROM files,platforms,resolutions WHERE
files.id=file_id AND resolutions.resolution = '$match_resolution' AND platforms.platform ='$match_platform'
iam getting error : Column 'file_id' in where clause is ambiguous
Please help me