Web Analytics Made Easy -
StatCounter select all from a database and find position of a certain entry - CodingForum

Announcement

Collapse
No announcement yet.

select all from a database and find position of a certain entry

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • select all from a database and find position of a certain entry

    I need to list everything from a database order by a certain field, which i can do, however i almost need to find the position of a entry (WHERE `userID` = '$userID') that would be the criteria, how would i do that? I can do a full DB search and a WHERE criteria search but i can figure out how to do a mix of both.

    EDIT: This would be done in PHP if that makes any difference.

  • #2
    Ummm...

    Code:
    SELECT list, of, fields
    FROM tablename
    WHERE somecondition
    ORDER BY somefield
    The parts of a SELECT must be given in that order.

    There are other parts that can be used, of course:
    Code:
    SELECT
    FROM 
    WHERE
    GROUP BY
    HAVING
    ORDER BY 
    LIMIT
    when used, they must be used in that order. (And there are even other much more rarely used parts that have to be in a particular order...and then there are joins and unions and subselects...but the above are the basic parts.)
    Be yourself. No one else is as qualified.

    Comment

    Working...
    X