database.... overskrift
HejJeg har en webshop med en database. Mit problem er at når jeg vil vise produkterne.... http://www.vels.dk/data/p1.asp?id=2 så vil jeg gerne have eks. det er en overskrift ved Abit Asus osv.... Men jeg syndes ikke lige min asp viden rækker til at lave det... nogen der har en ide? og evt en løsning?
Her min kode til p1.asp
--------------------------
<html>
<head>
<script language="JavaScript" src="net_time.js"></script>
<script language="JavaScript" src="frames.js"></script>
<title>V e l s D a t a . d k</title>
</head>
<body bgcolor="#B5BEAD" link="#FFFFFF" vlink="#FFFFFF" onLoad="InternetTime();" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" alink="#D2D2D2">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="700" height="1">
<caption> </caption>
<tr>
<td width="5" bgcolor="#004676" height="19" valign="top">
<p align="left"><img border="0" src="vt.jpg"></p>
</td>
<center>
<td width="119" bgcolor="#004676" height="19" valign="middle"><b><font color="#FFFFFF" face="Verdana" size="1">VelsData.dk</font></b></td>
<td width="422" bgcolor="#004676" height="19" valign="middle"><font color="#000000"> </font></td>
</center>
<td width="203" bgcolor="#004676" height="19" valign="middle">
<p align="right"><b><font size="1" color="#FFFFFF" face="Verdana"><%=date%> <font face="Verdana" size="1" color="#FFFFFF"><span id="reloj"></span></font>
</font></b></p>
</td>
<td width="6" bgcolor="#004676" height="19" valign="top">
<p align="right"><img border="0" src="ht.jpg"></p>
</td>
</tr>
<center>
<tr>
<td width="126" bgcolor="#FFFFFF" height="69" colspan="2" valign="middle">
<p align="center"> <img border="0" src="http://www.vels.dk/beta/1.jpg"></td></center>
<th width="360" bgcolor="#FFFFFF" height="1" bordercolor="#000000" valign="top">
<p align="center"> </p>
<p align="center"><font color="#FFFFFF" face="Verdana" size="2">
<%
if Request("id") = 1 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Blandet</font></b></center>"
end if
if Request("id") = 2 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Bundkort</font></b></center>"
end if
if Request("id") = 3 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>CD-brændere</font></b></center>"
end if
if Request("id") = 4 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>CD-ROM drev</font></b></center>"
end if
if Request("id") = 5 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Digital Kamera</font></b></center>"
end if
if Request("id") = 6 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Disk drev</font></b></center>"
end if
if Request("id") = 7 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>DVD drev</font></b></center>"
end if
if Request("id") = 8 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Grafikkort</font></b></center>"
end if
if Request("id") = 9 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Harddiske</font></b></center>"
end if
if Request("id") = 10 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Højtalere</font></b></center>"
end if
if Request("id") = 11 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Joysticks</font></b></center>"
end if
if Request("id") = 12 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Kabinetter</font></b></center>"
end if
if Request("id") = 13 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Kabler</font></b></center>"
end if
if Request("id") = 14 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Lydkort</font></b></center>"
end if
if Request("id") = 15 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Medier</font></b></center>"
end if
if Request("id") = 16 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Mini Notes</font></b></center>"
end if
if Request("id") = 17 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Modems</font></b></center>"
end if
if Request("id") = 18then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>MP3 Player</font></b></center>"
end if
if Request("id") = 19 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Mus</font></b></center>"
end if
if Request("id") = 20 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Net tilbehør</font></b></center>"
end if
if Request("id") = 21 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Netkort</font></b></center>"
end if
if Request("id") = 22 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Printere</font></b></center>"
end if
if Request("id") = 23 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Processor</font></b></center>"
end if
if Request("id") = 24 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Ram</font></b></center>"
end if
if Request("id") = 25 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Scannere</font></b></center>"
end if
if Request("id") = 26 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Skærme</font></b></center>"
end if
if Request("id") = 27 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Tasteturer</font></b></center>"
end if
if Request("id") = 29 then
Response.Write "<center><b><font color='#000000' face='Verdana' size='3'>Webcam</font></b></center>"
end if
%> </font></p>
</th>
<center>
</center>
<th width="204" bgcolor="#FFFFFF" height="1" bordercolor="#000000" valign="top" colspan="2" align="left">
</th>
</tr>
<tr>
<td width="135" bgcolor="#FFFFFF" height="125" colspan="2" valign="top">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" height="1">
<tr>
<td width="100%" bgcolor="#004676">
<p align="center"><b><font face="Verdana" size="1" color="#FFFFFF">->
Menu <-</font></b></p>
</td>
</tr>
<tr>
<center>
<td width="100%" bgcolor="#e4e9e9" valign="middle">
</center><form name="blah" method="post" action="#">
<p align="center">
<font face="Comic Sans MS">
<select name="dyr" onChange="window.location.href=this.options[this.selectedIndex].value;">
<option selected value = "default.asp">Vælg kategori</option>
<option value = "produkt.asp?id=1">Blandet</option>
<option value = "produkt.asp?id=2">Bundkort</option>
<option value = "produkt.asp?id=3">CD-brændere</option>
<option value = "produkt.asp?id=4">CD-ROM drev</option>
<option value = "produkt.asp?id=5">Digital Kamera</option>
<option value = "produkt.asp?id=6">Disk drev</option>
<option value = "produkt.asp?id=7">DVD drev</option>
<option value = "produkt.asp?id=8">Grafikkort</option>
<option value = "produkt.asp?id=9">Harddiske</option>
<option value = "produkt.asp?id=10">Højtalere</option>
<option value = "produkt.asp?id=11">Joysticks</option>
<option value = "produkt.asp?id=12">Kabinetter</option>
<option value = "produkt.asp?id=13">Kabler</option>
<option value = "produkt.asp?id=30">Kølere</option>
<option value = "produkt.asp?id=14">Lydkort</option>
<option value = "produkt.asp?id=15">Medier</option>
<option value = "produkt.asp?id=16">Mini Notes</option>
<option value = "produkt.asp?id=17">Modems</option>
<option value = "produkt.asp?id=18">MP3 Player</option>
<option value = "produkt.asp?id=19">Mus</option>
<option value = "produkt.asp?id=20">Net tilbehør</option>
<option value = "produkt.asp?id=21">Netkort</option>
<option value = "produkt.asp?id=22">Printere</option>
<option value = "produkt.asp?id=23">Processor</option>
<option value = "produkt.asp?id=24">Ram</option>
<option value = "produkt.asp?id=25">Scannere</option>
<option value = "produkt.asp?id=26">Skærme</option>
<option value = "produkt.asp?id=27">Tastatur</option>
<option value = "produkt.asp?id=29">Webcam</option>
</select></form>
</font>
<div align="center">
<center>
<table>
<tr>
<font face="Comic Sans MS">
<td width="75%"><b><font size="2" face="Verdana"><a href="http://www.vels.dk/data/news.asp"><font color="#000000">Nyheder</font></a></font></b></td>
</font>
</tr>
<tr>
<font face="Comic Sans MS">
<td width="75%"><b><font size="2" face="Verdana"><a href="http://www.vels.dk/data/tilbud.asp"><font color="#000000">Tilbud</font></a></font></b></td>
</font>
</tr>
<tr>
<font face="Comic Sans MS">
<td width="75%"><b><font size="2" face="Verdana"><a href="http://www.vels.dk/data/support.asp"><font color="#000000">Support</font></a></font></b></td>
</font>
</tr>
<tr>
<font face="Comic Sans MS">
<td width="75%"><b><font size="2" face="Verdana"><a href="http://www.vels.dk/data/info.asp"><font color="#000000">Info</font></a></font></b></td>
</font>
</tr>
<tr>
<font face="Comic Sans MS">
<td width="75%"><b><font size="2" face="Verdana"><a href="http://www.vels.dk/data/kotakt.asp"><font color="#000000">Kontakt</font></a></font></b></td>
</font>
</tr>
<tr>
<font face="Comic Sans MS">
<td width="75%"><b><font size="2" face="Verdana"><a href="http://www.vels.dk/data/"><font color="#000000">Forsiden</font></a></font></b></td>
</font>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
<center>
<a href="http://www.vels.dk/data/addprod.asp"><br>
<img border="0" src="http://www.vels.dk/data/images/indkobskurv.jpg"></a>
<a href="http://www.vels.dk/data/customer.asp"><img border="0" src="http://www.vels.dk/data/images/chekout.jpg"></a>
</center>
<p> </p>
<p> </p>
<p>
<center>
</center>
</p>
</td>
<td width="565" bgcolor="#FFFFFF" height="125" valign="top" colspan="3">
<div id="Layer1" style="position: absolute; width: 489; height: 328; z-index: 1; left: 296; top: 144; overflow: auto">
<center>
<p align="center"> <br>
<font color="#FFFFFF">
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Request.ServerVariables("APPL_PHYSICAL_PATH") & "\data\admin\scart.mdb"
SQLstmt = "SELECT * FROM products WHERE ccategory = " & Request("id") & " ORDER BY cname;"
'
'response.write SQLstmt
Conn.Execute (SQLstmt)
Set rs = conn.Execute(SQLstmt)
%> <%
DO WHILE NOT rs.EOF
ccategory = rs("ccategory")
catalogID = rs("catalogID")
cname = rs("cname")
cprice = rs("cprice")
Grosist = rs("Grosist")
cdescription = rs("cdescription")
cimageurl = rs("cimageurl")
ccode = rs("ccode")
catalogID = rs("catalogID")
%> </font>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%" bgcolor="#E4E9E9">
<tr>
<td width="53%"><b><a href="p.asp?id=<%=catalogID%>"><font color="#000000" face="Verdana" size="1"><%=cname%></font></a></b></td>
<td width="21%"><font face="Verdana" size="1"><b><font color="#000000">Pris:</font></b><b><%= FormatCurrency(rs("cprice"),2)%></b></font></td>
<td width="26%" valign="middle"><font face="Verdana" size="1"><b>
Antal:</b>
<input maxlength="1" name="fquantity" size="1" value="1">
<strong>
<input type="submit" value="Tilføj" name="order" style="font-family: Verdana; font-size: 8 pt; background-color: #004676; background-image: url('file:///E:/VELS.DK/bag2.jpg'); color: #FFFFFF; border-style: outset">
</strong></font></td>
</table>
</div>
<%
rs.MoveNext
LOOP
RS.Close
conn.Close
Set conn = nothing
Set SQLstmt = nothing
%>
</div>
</center>
</tr>
<br>
<p><br>
</p>
<tr>
<td width="691" bgcolor="#FFFFFF" height="42" colspan="5" valign="top">
<p align="center">
<font face="Verdana" size="1">Alle priser er inkl. 25% moms, eksl. leverings omkostninger.<br>
Der tages forbehold for tastefejl, prisændringer og udsolgte varer.<br>
© 2000 <a href="mailto:Data@vels.dk"><font color="#000000">VelsData.dk</font></a></font>
</p>
</td>
</tr>
<tr>
<td width="1" bgcolor="#004676" height="19" valign="bottom">
<p align="left"><font color="#FFFFFF"> <img border="0" src="vb.jpg"></font></p>
</td>
<center>
<td width="121" bgcolor="#004676" height="19"> </td>
<td width="420" bgcolor="#004676" height="19">
<p align="center"><font size="1" face="Verdana" color="#FFFFFF">© 1998-2000
<a href="mailto:data@vels.dk">VelsData.dk</a>
Alle rettigheder forbeholdes.</font></td>
</center>
<td width="205" bgcolor="#004676" height="19">
<p align="right"><font color="#FFFFFF"> </font></td>
<td width="1" bgcolor="#004676" height="19" valign="bottom">
<p align="right"><font color="#FFFFFF"><img border="0" src="hb.jpg"></font></p>
</td>
</tr>
</table>
</div>
<p align="center"> </p>
<p align="center"> </p>
</body>
</html>
