[RESOLVED] A little help

Mark_Nordstrom

Ill start out by saying I've done this before, but its been years and cant remember how.

I wanna query from one database WHERE name NOT LIKE '$name1'

$query_test = "SELECT * FROM test1 WHERE id=$id ORDER BY name ASC";
$test= mysql_query($query_test, $db) or die(mysql_error());
$row_test = mysql_fetch_assoc($test);
$totalRows_test = mysql_num_rows($test);
$name1=$row_test['name'];

$query_g1 = "SELECT * FROM test WHERE name NOT LIKE '$name1' ORDER BY name ASC";
$g1 = mysql_query($query_g1, $db) or die(mysql_error());
$row_g1 = mysql_fetch_assoc($g1);
$totalRows_g1 = mysql_num_rows($g1);

the problem is $name1 is multiple names right now it only sees the first name.

Mark_Nordstrom

thats my problem i cant get JOIN to work any examples would be awesome.

What i've tried is

SELECT test.name FROM test JOIN test1 ON test .name NOT LIKE test1.name GROUP BY test.name

The issue is test1 has hundreds of rows with the same name while the name field in test is unique.

vivek151189

so u can use the also make ause of subquery
something like this
select test.name from test where test.name is not like (select test1.name from test1) group by test.name
or u can make use of IN something like this

select test.name from test where test.name is not IN(select test1.name from test1) group by test.name

dalecosp

All of these sound a lot like CPU-eaters to me. Perhaps a better data structure could be put in place?

Mark_Nordstrom

Thanks for the help. I went ahead and just created a temp table of all names then did DELETE FROM test WHERE name='$name' inside of an array that called all the names from test1 it works how i want.