Results 1 to 2 of 2

Thread: Refining SELECT (*)

  1. #1
    Registered
    Join Date
    Jan 2012
    Location
    Tokyo
    Posts
    2
    Rep Power
    0

    Refining SELECT (*)

    Wondering how I can get database results to only show data that is still active, as opposed to 'deleted', but is still stored.

    When I use the following it presents me with records that are not valid anymore.

    $query = "SELECT COUNT (*) as this FROM that_table";

    I'm sure this could have been explained better, but I hope someone can give some guidance.

  2. #2
    Custom User Title entrecon's Avatar
    Join Date
    Aug 2006
    Location
    Michigan
    Posts
    2,742
    Rep Power
    17
    It all depends on your database structure and how it is managed.
    ________________________________
    Find me on twitter: @entrecon

Posting Permissions

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