I am rather new at this side of website design so please if you would bear with me a bit I would appreciate it.

I am first looking for an extension to do multiple updates of records displayed in a master type of page display. I have looked but I so far have been unable to find something to do that dealing with PHP and MySQL. My database is MySQL of course and language is PHP.. No I have not investigated anyother language yet. I am just learning a few of the ins and outs of PHP and really am swamped learning that..

If there is not an extension or behavior prebuilt that can be had or purchased could someone clue me the un-informed one in on it.. That way I will at least cut my losses and stop looking for one.

If the above is the case are there any tutorials on how to script a multiple update from a display such as I described above? If there are can someone point them out to me.. I sure would appreciate it alot..

And if anyone is out there that might tutor me a bit on this and other things when I get stuck or do you recommend subscribing to a particuar forum for such help I would really love to know that too. Right now am doing alot of self-teaching and it just is not going very fast and being more than average impatient I am really chomping at the bit to get some of these bits and pieces I have learned integrated into a coherent website and being productive.

I guess that is all for now just Let me say thanks to all you folks on here right now because I have been gaining alot of knowledge from reading the previous posts on here.. You folks sure are a smart and well informed crew of folks.. :&gt<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>
Thanks
Charlie



Life's journey is not to arrive at the grave safely in a well preserved body,
but rather to skid in sideways,
totally worn out and shouting ...
"HOLY SHIT ...WHAT A RIDE!!!"

Charlie,
You have described me to a "T". I am at about the same level as you in my php/mysql journey and I also need to update multiple records at once (I googled that search term adn found your post). Did you ever get an answer? Thanks,

Jim

If i understand ur request properly u want a multiple update script right?? So if u want a multiple update script firstly there's no prebuild script in php and even if it does exist it will probably not suite ur demands, the reason is becoz not every1 uses the same concept of programming in php by that i mean some people like to use function and some don't, some uses prebuilt function existed in php lib already some doesn't some create there own function. So can u elaborate a little bit more on what u need for e.g.
What kind of update are u looking for?
How many per page will b displayed?
Will it work with checkboxes etc..??

Please elaborate.
Regards,
Roddy

I can't speak for Charlie but my appication is for an online time tracking system. I am responsible for 4 employees and I keep up with the hours they work on a bi-weekly pay period. I am designing an application so that they can enter their own hours worked each day of the 2 week period. My table has each new date as a new record and I want to have a text box where they can enter hours worked (or sick leave, vacation, holiday, etc.). So I need a page that would show 14 days with a text box for each day and upon submit, 14 records are updated at once. This is so the employee does not have to go to a form for each day worked but can do 14 at once. Thanks.

So u need a script where your employees will come and enter the time they worked. It will be displayed as 14 days on a page for each employee, and at the end of the 14 days they will come over and enter the days and hours they worked 4. Am right so far??? Then what happen?? What other details needs to be entered?? I will try and help as much as i can with this.

Regards,
Roddy

Yes Robby,
You have it exactly. The only details entered will be what was worked for those 14 days (8 hours, 10 hours, sick, H, V, etc..). After updating, the page simply reloads with updated values showing. I have a page that lists all 4 employee's time for the 14 day pay period that I print out and turn in to the payroll department but they only need to see their own hours worked. I have everything working except for the mulitple updating of records.

The name is Roddy <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>
Ok do you have a time in and out???

Sorry Roddy,
No need for check in and out. Just a text box where they enter "8" or "10" or "H" or whatever.

Jim

Ok so the user will come in do they have to enter their names as well??? Then user will enter date they worked. Wat happen to sick and local?? Do u need another textbox for these as well??? User enter hours worked. And user submit.
Then Admin i.e. You come and get on a page the hours worked by all 4 employees right???

Regards,
Roddy

Do not need to enter their name. That is one of the fields and the record set is filtered by a hyperlink from the front page to just show that person's info. Text box will be 4 characters long. (The longest code we use for this is 4 characters) The text box will accept either the number hours worked, i.e. "8" or a code for why they were off (H = holiday, SLP = Sick leave, etc..) But everything else I think you understand.

I need n email to send the template. No coding has been done to it yet its just a simple page. I just need to kno whether u like it or not.
roddy.