|
<%
sql101="select * from products where tour_type like 'Domestic Tours' order by tour_state"
rs101=con.Execute(sql101)
if(!rs101.EOF)
{
chkId=new String()
chkState=new String()
while(!rs101.EOF)
{
chkId=rs101("news_id")
chkState=rs101("tour_state")
sql102="select * from products where news_id > "+chkId+" and tour_state like '"+chkState+"'"
rs102=con.Execute(sql102)
if(rs102.EOF)
{
sql212="select * from news where tour_city like '%"+chkState+"%'"
rs212=con.Execute(sql212)
if(!rs212.EOF)
{
%>
<%
}
}
rs101.MoveNext()
}
rs101.Close()
}
%>
|
|
<%
sql101="select * from products where tour_type like 'International Tours' order by tour_city"
rs101=con.Execute(sql101)
if(!rs101.EOF)
{
chkId=new String()
chkCity=new String()
while(!rs101.EOF)
{
chkId=rs101("news_id")
chkCity=rs101("tour_city")
sql102="select * from products where news_id > "+chkId+" and tour_type like 'International Tours' and tour_city like '"+chkCity+"'"
rs102=con.Execute(sql102)
if(rs102.EOF)
{
%>
<%
}
rs101.MoveNext()
}
rs101.Close()
}
%>
|