View Full Version : select all from a database and find position of a certain entry
08-24-2011, 01:58 AM
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.
08-24-2011, 02:19 AM
SELECT list, of, fields
ORDER BY somefield
The parts of a SELECT must be given in that order.
There are other parts that can be used, of course:
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.)
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.