getting position

Account Login

Latest Articles

The basic usage of PHPTAL, a XML/XHTML template library for PHP

by awuehr on 11-10-2008 in Tips & Tricks

Vulnerable methods and the areas they are commonly trusted in.

by Village Idiot on 11-04-2008 in Classes & Objects

Simple way to protect a form from bot

by codefreek on 10-23-2008 in Basic

The Basics On: How Session Stealing Works

by wiifanatic on 09-12-2008 in Security & Permissions

How to keep your forms from double posting data

by drewbee on 07-03-2008 in Tips & Tricks

IRC Channel

Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.

Associates

TalkPHP » getting position

LinkBack

Thread Tools

Search this Thread

Display Modes

06-27-2008, 10:31 PM	#1 (permalink)
mfolnovich The Visitor Join Date: Jun 2008 Location: Zagreb, Croatia Posts: 4 Thanks: 3	getting position So, I have mysql table users: ID name score and when getting position of user 'abc', I use: Code: $q = select * from users order by score; $o = mysql_query($q); for($i=0;$r=@mysql_fetch_assoc($o);++$i) if ($r["name"] == $username) return true; my question is how can I optimize it, I might have thousands of users ...

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT. The time now is 10:42 AM.