Results 1 to 4 of 4

Thread: MySQL Search... (Resolved)

Threaded View

  1. Mar 14th, 2003, 01:16 PM #1
    Daschle
    Daschle is offline

    Thread Starter
    Lively Member Daschle's Avatar
    Join Date
    Oct 2002
    Location
    Sunnyvale, CA
    Posts
    114

    MySQL Search... (Resolved)

    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.
    Last edited by Daschle; Mar 18th, 2003 at 07:25 PM.
    "It's difficult to imagine a world in which people voluntarily choose to listen to liberals. There is no evidence that it has ever happened. " - Ann Coulter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width