next »

[Timothy Jacobs]

But I'm not sure how to go about creating it.  I'd like to see it work, but I have literally no experience in PHP and MySQL.  My school district allows you 13 unexcused absences before you have to "appeal" (if you get sick and go over, you must have documentation from your doctor) for credit.  If your appeal fails, you loose your credit for the class you appealed for.  Anyway... I usually make a table in Word to track this.  (Examples:  Word 2003: http://ekhosofsylence.com/alog.doc  Word 2007: http://ekhosofsylence.com/alog.docx).  I was thinking it would be cool to do this with a PHP form and MySQL database.  But I'm completely useless when it come to that.  I was wondering if anybody would like to help me out with this.  I know there are a few people here that are excellent with this like Aldo and inportB, but anybody's help is well appreciated.  If you think you could be of any assistance, please drop me a line. 

[The Melancholy Of 110mb.com]

hmmm interesting... but sadly i dont really have time nor were to start... now depending on what you want in the Mysql i could help but PHP i cant do much now...

so if you say what info you want in the DB then i could say yes no maybe etc...

Also if one person does the Mysql and other on PHP ill help as it dont put stress on both people...

[Timothy Jacobs]

Thanks for the response.  I was sort of hoping for the SQL table to be structured like I have the Word table.  Then a form that you would fill in the details (like the cells in the Word table) and then have them stored to the DB.

[The Melancholy Of 110mb.com]

ok cool... but i have a question... i prob could do it all my self but the question is this:

If you could explain the following as im a bit confused: WD, Blocks, and remaining...

[Timothy Jacobs]

ok cool... but i have a question... i prob could do it all my self but the question is this:

If you could explain the following as im a bit confused: WD, Blocks, and remaining...

Ah... I've added some explanations in both (Word 2003, and 2007) files in the first post.  I would post them here, but they are easier to understand while visually viewing the table.  Something I can explain here is what a block is.  My school using block scheduling, opposed to regular (1st period, 2nd period, etc).  Each block is 1.5 hours, there are 4 a day.  Since they are 1.5 hours, one class (1 credit) fits into one semester.  Most people's schedules are 100% different each semester.  There are a few courses offered all year (both semesters) like band and choir.  I'm in band, so my third block never changes.  Confusing, I know, but it's a lot easier once your accustomed to it.

[The Melancholy Of 110mb.com]

so basically you have 12 absences per block yet possibly miss class 24 times correct? or AKA you have 48 absences before problems... as long as they are 12 each

any how i will try

[Timothy Jacobs]

so basically you have 12 absences per block yet possibly miss class 24 times correct? or AKA you have 48 absences before problems... as long as they are 12 each

any how i will try

You are allowed to get to 13, just cannot exceed it.  To save yourself trouble, forget the doubling thing.  Lets just go with 13.  That makes it easier.

[The Melancholy Of 110mb.com]

ok well i will prob create a form with check boxes i will try to get creative on it like images etc... but ill do the basic part first i just need to get a Mysql DB to be fast etc... but ill worry about that after the page the page will contain the form at the top and the results at the bottom or something like that... i should have it done by either today or tomorrow... not sure... but when do you really need it?

[Timothy Jacobs]

That sounds awesome.  You don't have to worry about design, I can probably do that myself, less work for you.  Would there be anyway that users could possibly delete entries as well?  If not, it's okay.  I don't need it by any certain date, I was just wanting to see if this was possible.  Thank you so much! 

[The Melancholy Of 110mb.com]

hmmm i will see but the date and delete option will come last ok? but ill do the basics first then work on dates and deleting <<< just dont like doing them...

[Timothy Jacobs]

hmmm i will see but the date and delete option will come last ok? but ill do the basics first then work on dates and deleting <<< just dont like doing them...

Oh, okay, gotcha.  Thank you very much, I really appreciate this. 

[The Melancholy Of 110mb.com]

NP i will start when i get home, as long as my mom dont bug me... but it should not be a problem as i already have something set up for posting and receiving data from mysql... all i need for that one is to learn arrays but i dont have time for it but i dont think i will need arrays in PHP for this

i will send you the link Via PM when i find it... as it may not even be on 110mb... should be though no idea though