select * ,pname as pname,subname_en as subname,descrip_en as descrip ,pname_fr as pname,subname_fr as subname,descrip_fr as descrip ,pname_sp as pname,subname_sp as subname,descrip_sp as descrip from #trim(prod_table)# where id=#trim(id)# and pname not like '' and pname_fr not like '' and pname_sp not like '' order by id select * from shop1 where pid=#trim(id)# and userid=#trim(islogin)# and ukeyx='#trim(iskeyx)#' and keyx=#trim(tkeyx)# #trim(default_meta_desc)##trim(site_title)#"> #trim(default_meta_kword)##trim(site_title)#">

#trim(temp_alt)#

#trim(getprods.pname)# #trim(getprods.subname)# #rtrim(getprods.descrip)# #trim(getprods.prod_size)# select id,prod_size from #trim(prod_table)# where id>0 and id<>#trim(id)# and (pname like '#trim(getprods.pname)#' or pname_fr like '#trim(getprods.pname)#' or pname_sp like '#trim(getprods.pname)#') order by prod_size Also Available in... Aussi disponible dans... También disponible en...  #trim(getprods2.prod_size)# Sorry, this item is not available Désolé, cet article n'est pas disponible Disculpe, este artículo no está disponible Qty: Qté: Ctd:  US #trim(dollarformat(getprods.price))# This item is already in your cart. Cet article a été déjà choisi. Este artículo ya fué seleccionado. #trim(link_text)#