MySQL PHP – SELECT WHERE id = array()? [duplicate]

by

Use IN.

$sql="SELECT * 
          FROM `table` 
         WHERE `id` IN (" . implode(',', array_map('intval', $array)) . ')';

More Related Contents:

  1. Getting links from db and displaying them in another div [closed]
  2. HTML Form/PHP connected but MySQL is empty
  3. Needle in a Haystack for Php [closed]
  4. Thank you for helping [closed]
  5. Create hyperlink from html table row to open record on a new page
  6. How to insert images into a database using PHP [closed]
  7. Multiple inputs with same name through POST in php
  8. Sum values of multidimensional array by key without loop
  9. HTML input arrays
  10. How to upload images into MySQL database using PHP code
  11. How to create a HTML Table from a PHP array?
  12. Notice: Array to string conversion in
  13. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  14. HTML – Change\Update page contents without refreshing\reloading the page
  15. “slash before every quote” problem [duplicate]
  16. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  17. mysql select query within a serialized array
  18. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  19. Echo menu tree with recursive function
  20. Sending HTML Code Through JSON
  21. Javascript function post and call php script
  22. PHP: Inserting Values from the Form into MySQL
  23. onbeforeprint() and onafterprint() equivalent for non IE browsers
  24. How to insert json array into mysql database
  25. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  26. Turkish characters are not displayed correctly [duplicate]
  27. PHP/SQL Insert Error when using Named Placeholders
  28. Create PHP array from MySQL column
  29. Save array in mysql database
  30. Using PHP to upload file and add the path to MySQL database

Leave a Comment