How to do a MYSQL query with an array in PHP?

Question

How can I query a database using the results of a prior query if they are in array? Below is what I have thus far.

$query = "SELECT * from searchtestdb where engname in ( SELECT synonyms.synonym  FROM words  LEFT JOIN synonyms ON synonyms.word_id = words.word_id WHERE word LIKE '%$searchBox%') ";

while($result = mysql_fetch_array($query)) 
        {
            echo $result['engname'];
            echo "<br> ";
            echo "<br> ";
        }

How can I get the $result['engname'] and query again? I'm thinking something like

SELECT * from searchtestdb where engname LIKE '%$result['engname']%';

but that obviously doesn't work. Any ideas?

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — rekire
– rekire, Commented Apr 20, 2013 at 6:28
Why would you want to query the same table again to get the same row? Are you going to use $result['engname'] and find rows that engGame is similar (hence the like) or do you want to find the same? — Μenelaοs
– Μenelaοs, Commented Apr 20, 2013 at 6:34

mehdi · Accepted Answer · 2013-04-20 06:30:16Z

2

while($result = mysql_fetch_array($query)) 
{
   $query2 = "SELECT * from searchtestdb where engname LIKE '%".$result['engname']."%';";
   $result2 = mysql_query($query2);
   while($row = mysql_fetch_array($result2)) 
   {
       echo $row["somthing"];
   }
}

answered Apr 20, 2013 at 6:30

mehdi

1,7552 gold badges15 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mortalus Over a year ago

good answer but i think some more explanation about concating strings is in order: For more info read this: php.net/manual/en/language.operators.string.php

Collectives™ on Stack Overflow

How to do a MYSQL query with an array in PHP?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related