Ronald Posted July 3, 2013 Share Posted July 3, 2013 (edited) i'v got the next array en now i want to create an sql statement where from de subarrays member_cat, overview_activity and overview_payment. $where shoud be where member_cat LIKE %Familie Dokters% AND etc.. Array( [newsletter_id] => 1 [newsletter_title] => dfdsafds322 [newsletter_subject] => dsfsdaf12 [newsletter_mailHTML] => dsfdsf dsf s fsdf ds fds fdfgdfgg [member_cat] => Array ( [0] => Familie A [1] => Familie B [2] => Familie C [3] => Test ) [overview_activity] => Array ( [0] => 15 ) [overview_payment] => Array ( [0] => 4 [1] => 7 [2] => 99 ) [NewsletterTest] => verstuur voorbeeld ) I've tried several possibillities with foreach. Anyone some ideas? Edited July 3, 2013 by Ronald Quote Link to comment https://forums.phpfreaks.com/topic/279828-create-sql-statement-where-from-multidimensional-array/ Share on other sites More sharing options...
AbraCadaver Posted July 3, 2013 Share Posted July 3, 2013 Your example where clause doesn't use anything in your example array. Post a complete where clause using the values from your example array. Quote Link to comment https://forums.phpfreaks.com/topic/279828-create-sql-statement-where-from-multidimensional-array/#findComment-1439315 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.