MySQL Search... (Resolved)

[Daschle]

This is a really basic, stupid question, but I can't find any website which will bloody answer the question.. it's all advanced stuff, and is well beyond my ability to grasp.

I have a SQL database called "downloads". There's several tables, one of which is "filename" and one of which is "downloads". Obviously, it's a download counter.

I'm trying to write a query that'll search the database and return the "downloads" value based on a single filename.

The standard query it uses is..
SELECT * FROM downloads ORDER BY downloads DESC

But that generates everything.

How would I just simply return the value of "downloads" where "filename" is blah, in table "downloads"?

Thanks.

[The Hobo]

Is this what you mean?:

SELECT * FROM downloads WHERE filename='blah.exe' ORDER BY downloads DESC

Sorry if I'm not understanding correctly.

[phpman]

This is a really basic, stupid question, but I can't find any website which will bloody answer the question.. it's all advanced stuff, and is well beyond my ability to grasp

then how can it be a basic, stupid question if you think it is all advanced stuff??

SELECT * FROM downloads WHERE filename LIKE '%blah.exe%' ORDER BY downloads DESC 

this will get all downloads that have the word blah.exe in it. Hobo's will return 1 row that will equal the word blah.

[Daschle]

Originally posted by phpman
then how can it be a basic, stupid question if you think it is all advanced stuff??

What's advanced to me isn't advaned to you, since that my knowledge of PHP and SQL can be summed up in five or six words.



Thanks for the info guys. Hobo's code worked perfectly, mainly because I'm able to guarantee that the scope of the file tracking is so limited that there'll never be a duplicate name.

Some day I'll learn the proper sql syntax so I can actually do more with it than track how many times my useless little program has been downloaded. (Up to 27 now! Yay me!)

Thnaks.