[PHP] sql query question

[tony]

hi

if i have  new  car and i want to search
each word in description
can i do
SELECT * FROM table WHERE
descript = new OR descript =car??

any help is appreciated

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] SQL Query Question

[Andrew Brampton]

Hi,
This isn't a php question, more of a SQL question, but I don't know any where better 
to send it, and I guess its trival enough for someone here to answer.

Anyway, I have a list of members each with a score field. How can I say that Member 3 
is ranked 10 out of 100 members for example.

Here is the layout of the members table:
ID, Name, Score

I can get the total count of members in the table, but I don't know how to determine 
what rank they are, unless I return all the rows in the table (sorted), and cycle 
through them until I find the member I want, counting how many people are above him... 
This method would work, but would be slow (and wastful), is there a better way to 
determine his position with a SQL Query?

Thanks in advance
Andrew

P.S
If it matters I'm using MySQL  PHP 4.0.6 on WinXP under Apache 1.3.22

Re: [PHP] SQL Query Question

[Jason G.]

Assuming you have the variable member_id (for the member in question)...
Get the score for that member and store it to $score...

SELECT score FROM members WHERE id=$member_id

Then to determine rank, just do this...
SELECT COUNT(*)+1 as rank FROM members WHERE SCORE$score;

-Jason Garber
IonZoft.com

At 08:47 PM 12/8/2001 +, Andrew Brampton wrote:
Hi,
This isn't a php question, more of a SQL question, but I don't know any 
where better to send it, and I guess its trival enough for someone here to 
answer.

Anyway, I have a list of members each with a score field. How can I say 
that Member 3 is ranked 10 out of 100 members for example.

Here is the layout of the members table:
ID, Name, Score

I can get the total count of members in the table, but I don't know how to 
determine what rank they are, unless I return all the rows in the table 
(sorted), and cycle through them until I find the member I want, counting 
how many people are above him... This method would work, but would be slow 
(and wastful), is there a better way to determine his position with a SQL 
Query?

Thanks in advance
Andrew

P.S
If it matters I'm using MySQL  PHP 4.0.6 on WinXP under Apache 1.3.22


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]