 |
<%
set newsproduct=server.CreateObject("ADODB.Recordset")
sqltext="select top 12 * from news where news10=3 order by news1 desc,id desc"
newsproduct.Open sqltext,cn,1,1
if newsproduct.bof or newsproduct.eof then
response.write "No Message!"
else
i=1
do while not newsproduct.EOF
set news6=newsproduct("news6")
set idd=newsproduct("id")
set news3=newsproduct("news3")
%>
|
|
<%
i=i+1
newsproduct.movenext
loop
end if
newsproduct.close
set newsproduct=nothing
%>
|
|
|
 |
<%
id=request("id")
set rs=server.CreateObject("ADODB.Recordset")
if id<>"" then
sqltext="select * from news where id="&id&""
else
sqltext="select top 1 * from news where news10=3"
end if
rs.Open sqltext,cn,1,1
set news3=rs("news3")
set news5=rs("news5")
set news6=rs("news6")
set news8=rs("news8")
set news12=rs("news12")
%>
alama's product range of sanitaryware, bathroom furniture, acrylic bathtubs, faucets and accessories, and ceramic tiles have made it unique in the world of bathroom architecture. Success has been achieved through the intelligent blending of technology, materials and design with a heightened sense of comfort, pleasure and sensuality.
All alama's products are centred around the most basic of elements, water, in an attempt to merge its sanitary function with a more enjoyable experience, and to bring its flow closer to a contemporary lifestyle.
Inspired by the Turkish bathing culture, a VitrA bathroom is a 'living space' where people can rest, read, pamper themselves, spend precious time on personal care, or share their space with someone special. In the spirit of the ancient Anatolian tradition of ceramic art, alama combines superior aesthetic concepts with sophisticated technology to redefine our relationship with water, and to reinvent the bathroom.
|
|
|
|
|
|
