Execute($sql1); while (!$rs1->EOF) { $gallery2_album_id =$rs1->fields["gallery2_album_id"]; $gallery2_album_pic =$rs1->fields["gallery2_album_pic"]; $gallery2_album_title_th =$rs1->fields["gallery2_album_title_th"]; $gallery2_album_title_en = $rs1->fields["gallery2_album_title_en"]; $gallery2_album_desc_th = $rs1->fields["gallery2_album_desc_th"]; $gallery2_album_desc_en = $rs1->fields["gallery2_album_desc_en"]; $gallery2_album_status =$rs1->fields["gallery2_album_status"]; $gallery2_album_add =$rs1->fields["gallery2_album_add"]; $gallery2_album_update =$rs1->fields["gallery2_album_update"]; //echo $gallery2_album_pic; if($gallery2_album_pic!=""){ $gallery2_album_pic_p = $path1.$gallery2_album_pic; } ?>