I have had quite a lot of response from this, so I felt I should elaborate. Basically, I am a DJ and every week I submit a chart of the Top 20 records I am playing. I want a form with 5 columns (Position, Artist, Title, Label, Misc) And then obviously I am entering that for all 20 tracks. The database table also has a datepost so I can select from the week ending when I posted them.
Thanks to everyone who has responded. Tom -----Original Message----- From: Robert Sossomon [mailto:[EMAIL PROTECTED] Sent: 24 June 2004 15:30 To: 'Tom Chubb'; [EMAIL PROTECTED] Subject: RE: [PHP] Posting Data to MySQL I actually found the perfect answer to this task in Google Answers. First you will need to know how your database tables are set up, secondly you need to figure out field names and such, thirdly you grab the data from the form and dump it into an insert statement (or update if the information was in the DB before). If you pass me some specifics I might be able to give you a hand. Robert -----Original Message----- From: Tom Chubb [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 9:19 AM To: [EMAIL PROTECTED] Subject: [PHP] Posting Data to MySQL I am trying to design a form that posts the data to a DB, but being new to PHP/MySQL, it takes me ages to hand write the code and I'm sure there must be an easier way to do it? My form has 100 fields using 20 rows and 5 columns and it's taking me ages to write the code for it. Can anyone advise how they code large forms like that and if you know of any software to make it easier? I've searched Google for hours and checked loads of Database scripts on sites like Hotscripts, but can't find anything. Thanks, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
