Need an easy way to update a table on my site.

Looking for volunteers to join your project? Need help with a script but can't afford to pay? Want to offer your services as a volunteer to build up your portfolio? This is the place for you...

Moderator: General Moderators

Post Reply
HMS Hajj
Forum Newbie
Posts: 3
Joined: Mon Jun 01, 2009 9:42 pm

Need an easy way to update a table on my site.

Post by HMS Hajj »

I would like a nice and easy way to update a table on my site. You can see what I'm currently using here. It's just an HTML page that I'm hand coding the new data in.

I'd like some thing that I could add the players name and Pilot name to and then use drop downs to select most of the other fields.

I can't pay much, but I might be able to swing a small amount to buy a case of beer or go out to dinner for anyone that feels up to helping me out.

Thanks,

Keith
itp
Forum Commoner
Posts: 67
Joined: Fri Jun 15, 2007 6:50 am

Re: Need an easy way to update a table on my site.

Post by itp »

Maybe you might want to take a look at this tool - phpmyedit
http://www.phpmyedit.org/article.php?features

First you create a mySQL database, you point this tool at your database and and it automatically creates an add/update/delete/view template for you to maintain the information.
HMS Hajj
Forum Newbie
Posts: 3
Joined: Mon Jun 01, 2009 9:42 pm

Re: Need an easy way to update a table on my site.

Post by HMS Hajj »

itp, thanks for the link and info. I will check it out and see if I can make it work more my needs.
HMS Hajj
Forum Newbie
Posts: 3
Joined: Mon Jun 01, 2009 9:42 pm

Re: Need an easy way to update a table on my site.

Post by HMS Hajj »

Okay, I created my database and table (my first ones!) and I've installed phpMyEdit and have entered some data into it.

My question now is, how do I make certian fields dropdown where I can select data that is already entered? Is that going to be a function of the SQL table its self, or some thing that phpMyEdit does? I'm very new to this as you can tell.

Thanks,

Keith
itp
Forum Commoner
Posts: 67
Joined: Fri Jun 15, 2007 6:50 am

Re: Need an easy way to update a table on my site.

Post by itp »

This type of tool can give you a head start on development, but when the business rules get a bit complicated you still have to roll up your sleeves and do some work.

Read the documentation & check their forum - look for "multiple select" or something like that.
Also read up on MySQL type SET.
Post Reply