Pass an array to a quyery string

[mjahkoh]

Assuming i had an array ($myarray) which holds maybe (1,2,3) how do i pass it in the query string so i get select hd from mytable where hd in (1,2,3). Please note that the array values are dynamic

Thanks

Jackson

 

[axiom82]

if (!empty ($array)){

 

    $where = "WHERE id=" . implode (' OR id=', $array);

 

}

 

$query = mysql_query ("SELECT * FROM table {$where}'");

 

 

[trq]

You nearly said it in your question.

 

<?php

  $arr = array(1,2,3);
  $sql = "SELECT * FROM tbl WHERE hd IN('" . implode(",",$arr) . "')";

?>

[websiterepairguys]

You nearly said it in your question.

 

<?php

  $arr = array(1,2,3);
  $sql = "SELECT * FROM tbl WHERE hd IN('" . implode(",",$arr) . "')";

?>

 

Keep in mind, this isn't a secure way of doing it.

 

If the values in the array come from user entered input (in this example, hard to tell), you need to sanitize each value.  That means looping through the array, and applying mysql_escape_string (or applicable db version) to each entry.  I would create a function for doing this.  Read up on SQL injection attacks.

 

Regards,

Mark