ok .. i have this little problem i am going through ... Leme explain this project of mine first .

I have a MS Access DB of student fields like ID no, Name, Marks .. etc .. This one Access DB would be updated by just adding more rows and would be done on the server. It looks sumthing like this:



Now .. I have a HTML page that shows this :


I would enter the ID number of a student (no authentication .. anyone can access anybodys marks), and when i hit submit .. I would be taken to a page that gets the values from the ID specified and shows it in the next page. The page design would be the same .. just the values comming in will depend on the ID number inputed in the previous screen.

The result should be something like this :



Is it possible to make a system like this ? To test this .. i will be using my own asta account .. so i guess if it works here .. then this system can be accessed from anywhere. Secondly, what language would be used ? HTML, PHP or ASP .. i'd preffer HTML .. but since HTML doesnt allow dynamic updating .. i am fine with PHP. But it would be nice if someone helped me out with this.

I think ..
Page1 : Enter ID ---> HTML
Page2 : Show results ---> PHP
DB : MS Access ..

Hope i didnt confuse, if so please let me know .. i'll try to explain in a better way if i can.

Regards
Dhanesh.

Arggggg ... Is the no one who can help this little code troubled .. frustrated .. irritated .. kid !

Regards
Dhanesh.

First of all, please do not double post. Second, you could put this data in a MySQL database and have a php page which downloads and checks information.

How the script should work:

A page called main.php (or whatever filename you want) should check if the student id exists, then go to results.php (or whatever filename you want). Then it should download the data from the database and show the details. Then it checks if the marks are higher then 75(or the pass level) and it displays "PASS!" or "FAIL!".

I suggest you google a good mysql and php tutorial.

Hope this helps,
souradipm

With much due respect (which by the way, u didnt have) , it wasent a double post with an intention to spam. A double post is considered ONLY if someone makes a consecutive post in a span of say 1 hr or 2 .. depending on the forum rules.

Now, for the post you made, it was EXACTLY the same thing i asked as a question. I know how it would work, I just need some code to get me started. And yes, i have gone to php sites and searched for this, but i was unable to get a decent tutorial.

Well, so next time please do not repeat the posts in your own words to gain points ..

Regards
Dhanesh.

Edit: I know it can be done in MySQL, and i have a working model, but my specifics include an MS Access DB

This post has been edited by dhanesh: Jul 18 2006, 07:03 PM

OK dhanesh,
I found a good database class library compatitable with access:
http://www.databasejournal.com/features/ph...cle.php/2222651
It uses PHP.

Sorry if I was rude to you or anything,
souradipm

This post has been edited by souradipm: Jul 18 2006, 07:44 PM

Ok well i decided to go with PHP since access was not a good idea ... i created a few things in php and mysql .. but it shure hell is driving me nuts .. will post a new topic with my experiments

Regards
Dhanesh.