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.