|
|
DRUGS
|
| |
| Red
Ribbon |
Donor |
Drugs |
Online
Donation |
Events |
News |
Links |
|
<%
if request("cat")="" then
cat="I"
else
cat=Request("Cat")
end if
if request("id")="" then
id="A"
else
id=Request("id")
end if
sql="select * from Product where cat='" & cat & "' and id='" & id & "' order by prod_id"
set rs=con.execute (sql)
%>
|
|
| Institution
/ Corporate
/ Individual
/ School / Organisation |
| |
|
|
|
|
<%
select case cat
case "O"
category="Organisation"
case "I"
category="Institution"
case "S"
category="School"
case "C"
category="Corporate"
case "IN"
category="Individual"
end select
response.write category
%>
<% if not rs.eof then %>
|
<% while not rs.eof %>
| Name
of the Drug |
<%=rs("Drug_name") %> |
| Detail
of the Product |
<%=rs("Detail") %> |
| Name
of company |
<%=rs("NameCompany") %> |
| Dose |
<%=rs("Dose") %> |
| Cost |
<%=rs("Cost") %>
Rs |
| Availability |
<% if rs("Availability")="T" then %>
Yes
<% else%>
No
<% end if %>
|
| Delear
List (Distributer) |
<%=rs("Dealer") %> |
| |
<% rs.movenext
wend %>
|
<% else %>
| No entries in this topic
|
<% end if %>
| |
| |
| |
|
|