quick question

[Anon]

$query = "SELECT * FROM archiveTBL where '$letter' like 'filename%'";

this makes sense doesn't it?
cause I keep getting no rows selected even if I have records in my DB.

[[deleted]]

Print the query to see if it makes sense.
Is $letter filled? and is 'filename%' correct?
Are there any records where the column named by $letter contains data that begins with "filename"?

[Anon]

vincent wrote:

Print the query to see if it makes sense.
Is $letter filled? and is 'filename%' correct?
Are there any records where the column named by $letter contains data that begins with "filename"?

yes, $letter is filled, and I meant
like '%filename'

[[deleted]]

So are there any records that should match?
does the query return records if you enter it from the commandline?

[steved]

If you are trying to find all the files that start with a certain letter, you would want to do:

$query = "SELECT * FROM archiveTBL where filename like '$letter%'";

This will work as long as your database table has a column named 'filename'. If not, you'll need to use the correct column name or a variable to represent the column name.