Basic task, unfortunately i have no idea how to do it!

Gilbretto

Gilbretto

Gilbretto

Associate
Joined
24 Nov 2007
Posts
888
Location
Leeds
Hi,

Basically, what i'm doing is designing a very very very simple website.

There will be a search box. It will comprise of Male (tick box) Female (tick box) and an age box, where you put in the desired age you are looking for.
Looking roughly like this!
example.jpg


Yeah, its supposed to be a very basic dating site. So you put in the sex/age you are looking for and you get a list of results.

Right! Now for the bit i have no idea how to do.

I need to make a database containing all of the results. Say 10 'people' of varing age and sex.

I then need to link the database to the search feilds, and then create a page to display the results.

I've been trying all sorts of things, reading guides for this and that. All i want is the most basic way of doing this. I'm getting confused! asp, php, mysql, apache, blah blah blah....it's all confusing me. I just want the simplist way!!

Everything must be contained on my computer (i dont have web space for a database). It all needs to be handed in on a cd.

Basically, the aim is to prove i can get the website to request data from the database and show the results.

Please, someone help me!

Thanks :),

Gil.
 
ok, all this confused the hell out of me. I found a guide telling me how to do a few things that i need using asp and Access databases.

So, this is where i'm at,

I have created a database with 10 men and 10 women of varying ages, this database is located on the server.

I can call up the whole table using this asp script,

Code: 
<html>
<head>
<title> Browsing a database file </title>
</head
<body>
<%
   Set MyConn=Server.CreateObject("ADODB.Connection")
   Set Rs=Server.CreateObject("ADODB.RecordSet")
   MyConn.Open("cgilboy-access")
   Rs.Open "SELECT * From SinglesList", MyConn, 1, 2
   Response.write("<TABLE BORDER=1> <TR>")
   
FOR i=0 TO Rs.Fields.Count-1
    Response.write("<TH>" & Rs(i).Name &"</TH>")
 NEXT
   Response.write("</TR>")
   
   Response.write("<TR>")
   While NOT Rs.EOF
    FOR i=0 TO Rs.Fields.Count-1 
	Response.write("<TD>" & Rs(i) & "</TD>")
    NEXT
    Response.write("</TR>")
    Rs.MoveNext
   WEND
   Response.write("</TABLE>")
%>
</Body>
</html>

SinglesList being the name of the database file.

So, I then need to link the database to the search feilds, and then create a page to display the results. I have no idea how to do this, i can't find a guide?

Can anyone help!? Please!?
 
You must log in or register to reply here.
Back
Top Bottom