Let $array be array (A, B, C)
I want use select for below purpose
select (*) form tablw where id=A or B or C <= content in the $array
how can I get that, Thx a lot
Moderator: General Moderators
Code: Select all
SELECT field1, field2, field3 FROM table WHERE id='A' OR id='B' or id='C'Code: Select all
<?php
// assuming $array = array('A', 'B', 'C');
$sql_info = "'".implode("', '", $array)."'";
$sql = "SELECT field1, field2, field3 FROM table WHERE id IN($sql_info)";Code: Select all
SELECT field1, field2, field3 FROM table WHERE id IN('A', 'B', 'C')Code: Select all
for ($i = 1; $i <= 6; ) {Code: Select all
$record=mysql_query($start_query);Code: Select all
$content=mysql_fetch_array($record_8);
Code: Select all
select * from member where refer_by = 'red_dots'