SitePoint Sponsor

User Tag List

Page 2 of 2 FirstFirst 12
Results 26 to 30 of 30
  1. #26
    SitePoint Evangelist
    Join Date
    Sep 2006
    Posts
    428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    AWESOME!!! Query is now working!! I went ahead and programmed in the qualification of all the db names.

    My last hurdle is determining the total number of results. In the past I have used:

    Code:
    SELECT FOUND_ROWS()
    But it only appears to return the LIMIT (30 in this case) and not the actual total number of results. Any advice on how to determine the number of actual results?

    Can't say thanks enough to you guys helping guide me on this!! You guys ROCK!!

  2. #27
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    FOUND_ROWS is supposed to be used in conjuction with SELECT SQL_CALC_FOUND_ROWS ...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #28
    SitePoint Evangelist
    Join Date
    Sep 2006
    Posts
    428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    would that route be the best way to determine the total result?

  4. #29
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    yes, that route
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #30
    SitePoint Evangelist
    Join Date
    Sep 2006
    Posts
    428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, almost all is well in the world of search! lol. The query is now running and returning pretty decent results.

    I just have some tweaking and fine tuning of some of my AND & OR & GROUP statements now and I'll be good to go.

    Thanks Again!!


Bookmarks

Posting Permissions

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