SQL Search: can someone point me in the right direction?

[perfectturmoil]

Hey.

I need to make a websearch for our SQL database. I want to check one column for keyword matches, and display the entries that match (Title: [whatever that's title is] Lot: [that entries lot number] etc).

I had a tutorial for .ASP that I used. I'd like to look into more robust options. Can someone point me in the right direction? That'd be great! Either ASP.net, PHP, or anything else that will get me my answer.

Heres an image of what I want my final product to be like... each of those tags are a column in the database, and the image is also derived from a tag in the database.

http://i5.tinypic.com/11s1ssp.jpg

So, if anyone has any suggestions of the best route to take (IE: which is the best answer, php, asp.net, something else), and any pointers where to find some info like tutorials and examples, that'd be great :- ]

[Tacoman667]

Use ASP.NET and SQLConnection object, an SQLAdapter object, and a dataset to pull out the information. You will need to write a SELECT statement as well. For example, SELECT * FROM tbl1 WHERE (rcd1 = "Today's Date").

That is not the exact syntax, if it is it was by mistake. :)

[klingens]

Best route depends on the server OS, webserver and not the least what you already know. E.g. php on IIS server is doable but certainly not the best way.

[maddog39]

I'm a PHP web developer and I do it like this in MySQL.


SELECT * FROM database_name WHERE row_name LIKE %keyword%

[Elif Tymes]

Ideally, you would not be using ASP, as that will require whatever host you are hosting it on to have a Microsoft license, which costs crapload of money.

You should look into learning PHP and MySQL as that would be the best system for creating a cross platform website.

[Tacoman667]

The server just needs to be a windows server with IIS installed. You could do this on your home computer running WinXP Pro. I have an ASP.NET site on godaddy for 7 bucks a month. 50Gigs, 200gigs bandwidth, a ton of emails that I will never use, and access to all HTML, ASP.NET 1.1 or 2.0, php, python, etc.

[perfectturmoil]

We're a company - trust me, a licence for SQL and Server 2003 is the least of our worries ;- ]

So PHP and IIS is a pain? If thats the case, ASP.NET seems like it may do the trick.

Is it similar in respects to ASP? Or did they tooootally change things around like they have a habit of doing?

[Tacoman667]

Few things are the same, but for the most part the .NET variety is different and far superior to plane jane ASP. I never had the pleasure of using ASP as schools went straight to .NET and that is all they teach now. I can say that ASP.NET is awesome and 2.0 makes it even better! go to ASP.NET on the web and see all you need to know. You can get Visual Web Developer Express 2005 for free from MS and it will do anything you need minuse a few tools that are only available with standard and above. Express will suit you all just fine though.

[Elif Tymes]

Eck. ASP is < PHP. PHP + APACHE is the way to go, gettin a LAMP(Linux, Apache, MySQL, PHP) server is simple and effective. Also, if you're company is planning on building a Database Web application, it may be advisable to hire an independant contractor for something like this.... Unless you want to do it yourself. In that case, I would seriously attempt to learn Ruby on Rails, and set up an Apache /Ruby on Rails server, there are quite a few different guides for that to.