Please help with this query.

[noj75]

Hi to all on this great site! I am desperate for some help:

 

$samesurn = "SELECT * FROM $stb WHERE s_sur IN (SELECT s_sur FROM $stb WHERE s_name='$proname') AND s_name!='$proname' ";

 

I am trying to do the above query:

 

$proname has a list of values in s_sur. I want to query the database to see who else has the same values and then display the results excluding $proname's own results.

 

This does work but is TERRIBLY slow. Is there another way to do this?

 

Any help is greatly appreciated. Thank you.

[RussellReal]

okay

 

first I want to recap:

$proname looks like it would be "first name"

 

I want to just make it clear that it is possible for people to name their kids their same name.. like

Russell Crevatas, Senior

Russell Crevatas, Junior

 

I'm stil not completely sure what this should be doing.. but you want everybody with the same last name, but not the same first name?

[sasa]

This does work but is TERRIBLY slow. Is there another way to do this?

can you explain TERRIBLY (more then 0.01 sec?)

[noj75]

Hi,

 

OK, $proname (s_name) is the username. So, if I ($proname) have entered a load of surnames into s_sur and I want to see who else (i.e which other usernames) have entered the same surnames as me I would have to query the database and show me the results. I only want to list other members surnames and exclude my own.

 

Does that clear it up?  ???