[Resolved] SELECT syntax error

Hi, I'm sorry to post this lame question, but if you would help me out, I will greatly appreciate it. Okay, here goes.

When I use this...

$query = "SELECT I.filename AS filename FROM $index AS I WHERE I.filename = $filename";
$result = mysql_query($query, $db) or die("AHHhhh!");

my script dies.

I know this is the problem because when I use something like:

$query = "SELECT * FROM $index";
$result = mysql_query($query, $db) or die("AHHhhh!");

the query is succesful.

Please help me if you can.
By the way, this query works properly when run manually.

Thanks.

$query = "SELECT I.filename AS filename FROM $index AS I WHERE I.filename = $filename";
$result = mysql_query($query, $db) or die(mysql_error());

Most likely, filename is a string, and you need to surround it with 'single quotes'

Also, can you mask a tablename with an AS statement...? I'm not sure on that one...

$result = mysql_query($query, $db) or die("AHHhhh!");

Might be better written:
$result = mysql_query($query) or die("AHHhhh!");

Cheers.

Thanks, superwormy. The problem was that $filename wasn't surronded by quotation marks.