Does this exist?

[motorbelly]

I hate trying to re-invent wheels. 🙂

I have a client who has information that changes for the 50 US States. Is there a script out there already that would allow a state name to be selected and then display MySQL table info about that state and have a form page to edit the information?

It seems relatively simple (compaired to all the portal thingys I find) and would have to be a first effort at php writing for me, but time counts and if it exists...

[techek]

Hiya

It would be fairly simple to make one SQL-query to select all available names from a DB.

Then when clicking a link next to every state name, you'd go to another page which receives the ID / name of a state, reads that exact record from the DB and displays the name and contents about the state in a textarea.

Then you can submit the form with state-id, state-name and state-content and update the record with the state-id.

Quite simple ...

/Techek

[motorbelly]

Originally posted by techek
Hiya

It would be fairly simple to make one SQL-query to select all available names from a DB.

/Techek

Simple for some. But It would be a project for me. I'll do it if there is no other way, but I thought there might be something to do it or edit that would be quicker. 🙂

[jnuneznyc]

Originally posted by motorbelly


Simple for some. But It would be a project for me. I'll do it if there is no other way, but I thought there might be something to do it or edit that would be quicker. 🙂

Well this is a bit specific... Break this out into different parts and find solutions to each. Like retrieving the states from the DB and placing it into a drop box is one part... (and I will be posting a quick tutorial on that tomorrow on another thread.)