Forum Home
Press F1
Thread ID: 64774	2005-12-27 11:59:00	Webdesign help	Aurealis_ (7897)	Press F1

Post ID	Timestamp	Content	User
416011	2005-12-27 11:59:00	Kia Ora . I have created a database using MS Access and I am now trying to convert it into a web page . So far I have transformed the information into an HTML based list, which you can view . ihug . co . nz/~bolam/Avengers%20Database . html" target="_blank">homepages . ihug . co . nz (here) Now, one of my problems is that the list is static . There are 186 entries and the only way to find a specific entry is to manually browse the entire list . What I want to do is create an automated search function, so that users can enter any given criteria, say MAV-200 and the site will return entries that match that criteria in any given field . If it were possible to search in a specific field (e . g . MAV-200 in Collector #) that would be even better . A bigger problem still is that I have no idea how to do the above . I need help . If anyone can help me to create something to solve this problem I would be really greatful . Unfortunately I am a skint Uni student, so I can not afford to pay anyone (unless you play one of the TCGS: VS, DM or MTG, in which case I could pay you in cards) cash for any help given . I would prefer a solution based solely in HTML, but I expect my criteria can only be fulfilled using SQL . The relevant tools I have access to are: MS Access 2002, Dreamweaver MX, and an FTP Server . Once again, I will be extremely thankful to anyone who can help me out . Cheers, Logan .	Aurealis_ (7897)
416012	2005-12-27 12:45:00	I'm not sure about the automated methods Access provides (such as the web based forms, which I have used very little), but the easiest way to do this would indeed, as you anticipated, be through the use of SQL. I'm not sure if you've said this, and I'm sorry if you have, but I presume your site is just an html table in which you have manually written the database contents? If so, let me tell you about a magical world - a magical world of possibilities, opportunities and endless amazement... a world in which you will find exotic things never thought to exist in the real world of man! I speak, ofcourse, of server side scripting, and SQL. If you're keen to use it, first thing to do is to check with your hosting provider on what exactly they provide. Commonly catered for server-side languages include PHP, and ASP. If you have code experience with VB, then you'll be interested in ASP. If you've any code experience in C/C++, Javascript, shell scripts, or anything that uses curly braces, then check out PHP. It may be a little hard to learn at first, but the eventual outcome is so much better than a static page that it can't be expressed in words. I'm sure there are many of us who are willing to help you out with the code, if not even do it for you...	Growly (6)
416013	2005-12-28 01:26:00	I'm not sure about the automated methods Access provides (such as the web based forms, which I have used very little), but the easiest way to do this would indeed, as you anticipated, be through the use of SQL . I'm not sure if you've said this, and I'm sorry if you have, but I presume your site is just an html table in which you have manually written the database contents? If so, let me tell you about a magical world - a magical world of possibilities, opportunities and endless amazement . . . a world in which you will find exotic things never thought to exist in the real world of man! I speak, ofcourse, of server side scripting, and SQL . If you're keen to use it, first thing to do is to check with your hosting provider on what exactly they provide . Commonly catered for server-side languages include PHP, and ASP . If you have code experience with VB, then you'll be interested in ASP . If you've any code experience in C/C++, Javascript, shell scripts, or anything that uses curly braces, then check out PHP . It may be a little hard to learn at first, but the eventual outcome is so much better than a static page that it can't be expressed in words . I'm sure there are many of us who are willing to help you out with the code, if not even do it for you . . . Currently I am using the Ihug webspace which comes with my internet service and supports only HTML and CGI (I think), but I will be purchasing space with capacity for PHP, SQL and Apache within the next few weeks . I have no experience with coding . I tried C++ once and I just couldn't sustain interest . I preferred the hardware side of computers . The site is currently formatted in an HTML table . I used the MS Access software to export as an HTML document . I couldn't be bothered writing it if I didn't have to, so I was well pleased to see the result . If you want to check out the site, it is viewable here ( . ihug . co . nz/~bolam/Avengers%20Database . html" target="_blank">homepages . ihug . co . nz) Cheers .	Aurealis_ (7897)
416014	2005-12-28 06:34:00	You need to learn one of the server side scripting lanuages, Growly has already listed them. The only way to search your web page (provided link) is with the find function of your browser (or f3 key). Php is not that hard and there is plenty of help on the web There maybe a alternative through create a search function for the web pages using java script heres one example I found (isnt google wonderful :D) javascript.internet.com	beama (111)
1