Admin page coding?

[awayne]

Just wondering if anyone can suggest somewhere I can find code for an admin page? I have a database that has name, address, city, state, zip code and telephone number... and I also have a relationship table for the states. Please let me know if there is anywhere I can find something that will work. I want to be able to edit any of the data already in the database and also add a new entry.

Thanks
Wayne

[Bullschmidt]

TableEditoR
http://www.2enetworx.com/dev/projects/tableeditor.asp

[whammy]

http://hotwired.lycos.com/webmonkey/02/35/index4a.html?tw=backend

Check out their query.asp page - it's what I use with very slight modification. Not to mention typing in SQL is a great way to get really good at it.

[awayne]

I am trying the table editor that was in the first reply. I do have one little problem. Since I have a relationship between 2 tables.... The first table is the state and the second table is an id. This is so only one of each state that is present in the database will show up on the list. What can I do so that I can have the state show up in the drop down list on the admin page? Currently I only have numbers (the ID numbers that is)

Thanks
Wayne

[raf]

awayne,

this paralel help-circuits (mail + forum) aren't (in my honest opinion) the best way to go.

this forum is great for fixing (punctual) problems/exchainging tips and ideas/learning bij experience etc.
Buth posting problems here + copying/downloading scripts without actually knowing what they mean, isn't the best way to learn programming. You might get your site up and running, buth that's not why we're here (at least not why i am helping you)

you need to learn some things about databasedesign and sql. its not that hard and it will probably only take you a day or so.

check out this link
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial3.html

+

post your punctual questions here and mail me for more general problems/questions. as soon as my workshop-site is up, we'll be able to take them on there.

[whammy]

I'd agree... it sounds like you just need to do a join statement in SQL.