KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
i have a problem making a SQL Query with an array in my WHERE clause. For example: My Array: $myarray[1] = "hi"; $myarray[2] = "there"; $myarray[3] = "everybody"; My MySQL Statement: SELECT * FROM myTable WHERE title='".$myarray[]."' Is there any way to realize that? I solved it myself like this: for(...) { $where = $where." title='".$myarray[$count]."' OR "; } $where = substr($where , 0, -3); ..... SELECT * FROM myTable WHERE ".$where." But if i had thousands of entries in my array, the SQL Statement would be too big and slow, right? Thanks
Tags (comma-separated)
Save Edits
Cancel