err I thought ASP was ASP.NET *cry hmmm whats it involve and the advantages are? Im sure this should be really really simple! I have done the table, i just need to do a bit of styling, like the font size, colour and heading cell background colour. again any help much appriciated

Could you give me an example to work with, not familiar with tables either, but i am learning!and its working, just need to colour it now Thanx again

http://www.driffieldbroadband.co.uk/lwa.asp[^] i decided to re-write it all, found a few probs, now fixed :D but how do i implement styles to say the headings cell but not the actual data cells, say i want the heading cells with a blue background but the data cells a white/no background? thanx for all the feedback..

*cry* Im lost! http://www.driffieldbroadband.co.uk/lwa.asp[^] I got some tables though... any help appricated!

Thanx! i will give that ago i thought it was something down the lines of that, but i dont wanna be messing about and getting lost, arg programming! i hate programming! im a hardware man! Thanx, will let you know how it goes...:laugh:

<%@ Language="VBScript" %> <% Option Explicit %> Low Wing A - Pattern List <% 'declare your variables Dim Connection, Recordset Dim sSQL, sConnString 'declare SQL statement that will query the database ******* NAME OF TABLE ******* sSQL="SELECT * FROM lwa" 'define the connection string, specify database 'driver and the location of database sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Server.MapPath("../databases/lwa.mdb") ' ****** LOCATION OF DATABASE ******* 'create an ADO connection and recordset Set connection = Server.CreateObject("ADODB.Connection") Set recordset = Server.CreateObject("ADODB.Recordset") 'Open the connection to the database connection.Open sConnString 'Open the recordset object, execute the SQL statement recordset.Open sSQL,connection 'first of all determine whether there are any records If Recordset.EOF Then Response.Write("No records returned.") Else 'If there are records then loop through the fields Do While Not recordset.EOF Response.Write recordset("PICTURE LINK") & " " & recordset("AIRCRAFT TYPE") & " " & _ recordset("AIRCRAFT MODEL") & " " & recordset("COCKPIT") '******** SPECIFIED FIELDS ******* Response.Write "
" 'insert a line break 'move on to the next record Recordset.MoveNext Loop End If 'close the connection and recordset objects and free up resources Recordset.Close Connection.Close Set Recordset = Nothing Set Connection = Nothing %>

Hi I am totally new to ASP and need some help. My scenario is this... I have a database that i want to show in a html style table, i have it so far that it shows the data but not in any table style. Also how do you show the field titles. here is what i have so far... http://www.driffieldbroadband.co.uk/lwa.asp[^] Any help would be fantastic, thanx!