is there any way i could minimize this mysql query?

Obsgard

New Member
i am developing an application which have eight advertisement boxes, the advertisement data with position is stored into the database. the advertisement module works like first it will check if the particular position exist in the database (i.e 1 to 8) if it finds or not find it will return a Boolean accordingly. for that reason i am using a user defined function like this.\[code\] function dbgetvar($query) { $res = mysql_query($query); if( !$res) { trigger_error("dbget: ". mysql_error(). " in " .$query); return false; } if( mysql_num_rows($res) == '0' ) { return false; } $row = mysql_fetch_array($res); if(!$row) return ""; return $row; }\[/code\]as i have to make the eight queries i am doing it somewhat like this.\[code\]$adbox1 = dbgetvar("SELECT advertisements.id as 1_id, advertisements.pic_brief as 1_brief FROM advertisements WHERE pos = '1'");$adbox2 = dbgetvar("SELECT advertisements.id as 2_id, advertisements.pic_brief as 2_brief FROM advertisements WHERE pos = '2'");$adbox3 = dbgetvar("SELECT advertisements.id as 3_id, advertisements.pic_brief as 3_brief FROM advertisements WHERE pos = '3'");$adbox4 = dbgetvar("SELECT advertisements.id as 4_id, advertisements.pic_brief as 4_brief FROM advertisements WHERE pos = '4'");$adbox5 = dbgetvar("SELECT advertisements.id as 5_id, advertisements.pic_brief as 5_brief FROM advertisements WHERE pos = '5'");$adbox6 = dbgetvar("SELECT advertisements.id as 6_id, advertisements.pic_brief as 6_brief FROM advertisements WHERE pos = '6'");$adbox7 = dbgetvar("SELECT advertisements.id as 7_id, advertisements.pic_brief as 7_brief FROM advertisements WHERE pos = '7'");$adbox8 = dbgetvar("SELECT advertisements.id as 8_id, advertisements.pic_brief as 8_brief FROM advertisements WHERE pos = '8'");\[/code\]and then i fetch the data like this. \[code\]if($adbox1){ echo "I am found";}if(!$adbox1){ echo "I am not found";}\[/code\]although it works fine, it is messed up and a huge queries is piled up. i want to clean and minimize it if possible. what is your take?
 
Back
Top