Finding multiple rows

[nca]

I have this...

$a1 = "SELECT ID FROM table WHERE NAME LIKE '%".mysql_escape_string($name)."%'"; 
$a2 = mysql_query ("$a1");
if (mysql_num_rows($a2)==0) echo "NOT FOUND";
while ($row=mysql_fetch_array($a2)){ 
$recipient = $row[0];
if (!$recipient_array) {
	$recipient_array = "'".$recipient."'";
} else {
	$recipient_array = $recipient_array.","."'".$recipient."'";
}
}

It will give me a listing like this...
'1','42','322','932'

How do I then write a mysql query to find all records that have at least 1 of these in the colum named "ids"?

[cgraz]

I haven't looked at your code, but lets say you have '1','42','322','932' stored in a variable called $numbers. You could do

SELECT * FROM your_table WHERE ids IN($numbers)

in is the same as using OR

WHERE ids='1' OR ids='42' OR ids='322' OR ids='932' etc

Cgraz

[nca]

$a1 = "SELECT ID, NAME FROM table WHERE NAME LIKE '%".mysql_escape_string($name)."%'"; 
$a2 = mysql_query ("$a1");
if (mysql_num_rows($a2)==0) echo "NOT FOUND";

while ($row=mysql_fetch_array($a2)){ 
$recipient = $row[0];
if (!$recipient_array) {
	$recipient_array = "'".$recipient."'";
} else {
	$recipient_array = $recipient_array.","."'".$recipient."'";
}
}

$b1 = mysql_query ("SELECT ID, NAME FROM table2 WHERE IDS IN ($recipient_array) ORDER BY ID DESC");
$b2 = mysql_num_rows($b1);
$b3=mysql_fetch_array($b1);

echo "<h3>$b2 Matches</h3><br>";

if ($b2) {
while ($I < $b2) {
	echo "<b>$b3[0] $b3[1]</b><br>";
	$I++;
}
} else {
	echo "NO MATCHES";
	}

Could you tell me why this will keep repeating the same result in the last while. I don't know very much about php just yet to do this kinda stuff.

[cgraz]

What's the value for $I? I think you're confused with a for loop:

for ($i=0; $i < $b2; $i++)
   echo $var[$i] . "<br>\n";
}

Anyways, use this:

$b1 = mysql_query ("SELECT ID, NAME FROM table2 WHERE IDS IN ($recipient_array) ORDER BY ID DESC");
$b2 = mysql_num_rows($b1);

if ($b2 == '0') {
   echo "No Matches"; 

} else {

   echo "<h3>$b2 Matches</h3><br>";

   while ($row=mysql_fetch_array($b1)) {
      print "ID: " . $row["ID"] . "<br>\n";
      print "Name " . $row["NAME"] . "<br>\n";

   }


}

Cgraz

[cgraz]

Ahh, I'm not very good with LEFT JOINS, I don't have much experience, so I don't know if this will help, but shouldn't

LEFT JOIN info ON table.ID

be

LEFT JOIN info ON bline.ID

Cgraz

[cgraz]

LEFT JOIN info ON table.ID=table2.ID,PLE WHERE $searchterms ORDER BY table.ID, table2.PLE DESC";

PLE (at the beginning) is just kind of sitting there with a comma before it. and your WHERE clause has no fieldname for $searchterms to equal.

WHERE field='$searchterms'

That's about all i notice. Hopefully someone else will step in and help here. I'm not very experienced with joins at all. 🙁

Cgraz