Help With this query?

[NOJ75]

Hi guys,

This is really bugging me as I cant get it to work:

$proname = "John";

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

$sameresult = mysql_query($samesurn);					

while($samerow = mysql_fetch_array($sameresult)) {

$matchsur = $samerow['s_sur'];

echo $matchsur;

$samerow++;					
}

I am trying to do this 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.

Hope that makes sense. The error I get is mysql_fetch_array(): supplied argument is not a valid MySQL result.

Any help greatly appreciated.

[NOJ75]

OK,

It works when I do this:

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

But it is REALLY slow!!

Any ideas?

[Weedpacket]

It's always a bit worrying to see the name of the table being stored in a variable like it might be different.

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

So, let me get this straight: you get all of the s_sur values from $stb where s_name equals $proname, and then get all the rows where s_sur is one of those values but s_name does not equal $proname.

Select s2.* from $stb s1, $stb s2 where s1.s_sur='$proname' and s2.s_sur!=s1.sur