-----------------------------------------------
Excellence in internet and open source software
-----------------------------------------------
Sunmaia
www.sunmaia.net
tel. 0121-242-1473
-----------------------------------------------
-----Original Message-----
From: Paul Romanic [mailto:[EMAIL PROTECTED]]
Sent: 30 September 2002 03:53
To: [EMAIL PROTECTED]
Subject: A rookie question
Hello, and apologies for such a novice question...
>we were all there once :)
I have a need to find a method to allow a user to update information on
members of our organization. The typical number of students' info that needs
updated is 50-75. The info to be updated is grade change, and year of Latin
change for each student.
My initial thought (if I transfer the database to MySQL from FileMaker) is
to set up the database as a relational database with students in one table,
the schools in a second and the school name being the link.
The real question is...if I use PHP to access MySQL, can I allow the user to
edit the records (or portion of them) from one Web page with ONE submit
button? Is this even possible? I want know I could do this with a submit
button for each member, but that would not be too end user friendly!
>yes
> my usual approach is to have the form fields labelled so they return an
array. You then work through the array in the script that you post to,
updating one record at a time.
>You may find examples out there, http://www.phpbuilder.com is good source.
>If you need any more information email me offlist and I will send some
sample code.
HTH
Peter
Thanks for putting up with a novice question, and any help you can offer!
Paul
____________________________
J. Paul Romanic, R.A.
State Chair
Ohio Junior Classical League
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
