Posted by julian_m on 11/22/05 07:36

let's say I've an array of articles's id

$arr_art_id=(1, 551, 2015, 6 .......n )

what option is better (1 or 2), in order to achieve better performance?

(pseudo code)
1)
for i=0 to array count{
select * from articles where articles.id=$arr_art_id[i]
mysqlquery($sql)
//do whatever i have to do
}


2)

$or ='';
for i=0 to array count{
$sql.= $or . 'articles.id='. $arr_art_id[i];
$or ='or';
}

$sql = 'select * from articles where' .$sql

mysqlquery($sql)
//do whatever i have to do

tia

regards - julian maisano

[Back to original message]