File selecting not working

[EPCtech]

Hi,

I have an upload file system so that users may post their own games on my website for my visitors to play. It's supposed to select files that only the user has posted. But for some reason it selects all files or half of the files.

 

$sql=mysql_query("SELECT * FROM myfiles WHERE user='".$USERname."' AND (file LIKE '%.zip') OR (file LIKE '%.gmk') OR (file LIKE '%.exe')");

This code gets me files from a user named "coffee".

 

Is there anything wrong with my code? I hope I described it well enough.

 

En-Psyche

[dreamwest]

Looks fine. Make sure $USERname has a value  by echoing it out

[Maq]

I think you want your query like this:

 

$sql=mysql_query("SELECT * FROM myfiles WHERE user='".$USERname."' AND (file LIKE '%.zip' OR file LIKE '%.gmk' OR file LIKE '%.exe')");