Page 1 of 1
Need an easy way to update a table on my site.
Posted: Mon Jun 01, 2009 9:47 pm
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
Re: Need an easy way to update a table on my site.
Posted: Sat Jun 06, 2009 9:42 am
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.
Re: Need an easy way to update a table on my site.
Posted: Sat Jun 06, 2009 10:31 am
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.
Re: Need an easy way to update a table on my site.
Posted: Wed Jun 10, 2009 7:11 am
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
Re: Need an easy way to update a table on my site.
Posted: Wed Jun 17, 2009 10:24 am
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.