Linking an online search to a database?

[Kelly_]

I have created a database and now I need to be able to put a search so that people can choose what they want and then it will search the database and pull out the specific information.

I have tried loads of different ways and it just doesn't seem to work! It needs to be like this http://www.onevoice.co.uk/courses.php

I have tried http://www.asp101.com/samples/db_search.asp
http://www.learnasp.com/freebook/asp/SQLwhereform2.aspx
http://www.aspnetcenter.com/cliktoprogram/asp/AddDataForm.asp

It says it just can't find it. What the hell am I doing wrong?? I don't know php and just basic asp so things are really confusing me the ODBCs and the SQL. Has anyone done this before and fancy telling me how?

Cheers, Kelly

 

[MikeDX]

I can help if you are using php and mysql, but sadly asp and odbc's and whatnot are a bit out of my range without doing some research.

 

[Kelly_]

Can I use mysql within asp pages or is that a stupid question? I haven't got a clue of the best way to do it.

 

[MikeDX]

you can link asp to mysql using a system DSN.. but personally I cant stand using windows as a server platform

 

[Kelly_]

Some company we work with has just rang talking about uniservity and they want us to have our website within their content mgt software. He was going on about how much easier it will be to use the cms opposed to having the normal website... Do you know anything about http://www.uniservity.com/

 

[Gav76]

i only know asp as well and I would just add the mySQL as the DSN with the correct driver. For another page I use something like;

On Error Resume Next
myname=request.form("Username")
mypassword=request.form("Password")

Set MyConn=Server.CreateObject("ADODB.Connection")

MyConn.Open "Driver={SQL Server};Server=serverx;Uid=" & myname & ";Pwd=" & mypassword & ";Database=dbname"
sqltemp="Select test from tablename"

set rs=MyConn.execute(sqltemp)

Then use the recordset to build your content.

 

[bigmouk]

what type of database have you created ?

 

[Kelly_]

I've done an access database. I've tried something along the lines of what Gav76 suggested but its not finding the information.... god knows what I have done wrong.

 

[Gav76]

Does it give an error? Or you got some code?

What if you just build an empty page with the code above and try to show the first record? Then does it work?