Automatically creating list

Anon

Hi,

I'm creating an admin script that writes a set of data (each row about a particular video game) to a mysql table.

The first page my users see is 'new game(row)', or 'edit current game (row)'.

If they select new, they go to new.php, and can fill in and create a new game listing - easy.

If they click edit, I need a list of all the games in the database, so that you can click on one and be able to edit the columns I specify for that particular game.

In this way, I only have to create the page once, and the data in the form is just different, depending on the game. My problem is, I don't know how to create this linking list... any help or code examples would be met with gratitude.

James

Anon

I can't help you with your coding problem exactly as I'm not sure I understand. However, if all you are wanting to do is add/edit/view and delete rows from a database using a HTML form then I have a php script that can do that for you. It is completely customisable allowing you to specify the HTML form types you want. It has most Form types including file upload abilities.

The main page in the script just shows a listing of all the games with the buttons view/edit/del next to each row allowing you to modify the information in the database.
If you want to see an example of the interface then you can look at the perl version I have written. It is exactly the same but it doesn't use a proper database but dbm files instead. This example can be seen here:
http://www.leigh.canberra.net.au/folio/demonstration/partygames.cgi

The php version of this works, but isn't 100% finished. It currently only works for msql databases and doesn't have all the HTML input stuff I want yet. But it should be easy to modify. If you are interested then send me an email and I will send you copy.