Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show student marks with search engine

Status
Not open for further replies.
Si14

Si14

Programmer
Apr 4, 2010
1
CA
Dear all:

I have about 20 students. Each has a number and a mark.
I want to design a page with a search box in such a way that when some one enters his/her number in that search box and press "search", the result would be his/her mark.

How can I design this page with front page?

Thank you very much.
Regards
 
Sort by date Sort by votes
Put the students in a database, say access. You just need one table with the student_name, student_id, mark.

Make sure ODBC for Access is on your system. It is if access is installed.

Now use the database wizard in FP to generate the page for you: just follow the instructions.

On the generated code, split it into 2: one for your side and the other for the response.

The query will be something like "SELECT * FROM MARKTABLE WHERE student_id=" & :studentid

That is basically it.

More information on
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How to migrate a FP-website to a server without FP-extensions ?
Replies
0
Views
447
leifoet
leifoet
reble
  • Locked
  • Question
re: some help with front page 2003 please
Replies
1
Views
2K
reble
reble
sap1958
  • Locked
  • Question
Frontpage 2003 Not Compatible with Windows 7 1
Replies
7
Views
690
xwb
xwb
Bluejay07
  • Locked
  • Question
Webpage not seen by search engines
Replies
2
Views
232
Bluejay07
Bluejay07
nomad674
  • Locked
  • Question
trouble with forms
Replies
3
Views
294
keepingbusy
keepingbusy

Part and Inventory Search

Sponsor

Back
Top