I got it. So yeah, try dreamweaver, as that might speed up / automate
your production.
The other thing to try is condensing your code, depending on how your
DB is set up.
That is, you can use a simple loop to build the form (you code for one
row of the form, and loop it out 20 times)... name your forms like
this: position[], artist[], title[], etc. etc.
That way when the form is submitted, it will send the data as an array.
then you can loop out the insert code 20 times, and use counter
variable (such as $i ) to point to which one you want... quick
example:
for ($i = 0; $i < 20; $i++) {
$insert = "INSERT into TBL (artist, position, title) VALUES
(".$_POST['artist'][$i].",".$_POST['position'].",".$_POST['title'][$i].")";
}
like i said this is a very quick example, but i wanted to use it to
show you a couple things:
1) using the $i var to point to the branch of the array you are trying
to get at.
2) remember arrays start counting at 0, and the above code will stop
at 19 (0 thru 19 = 20). you can use the same loop to loop out your
form too.
also, you should put the execution of the sql query into the actual
loop, so that it fires off each time, inserting the record. Include
the date on each row of the data, so when you want to get a particular
week, select using the DATE field, and order it by your position
field. This is your easiest bet. Don't try to have a row in the
database that has all 20 of your picks on one line... as that would be
more difficult to code, and would probably kill you on DataBase
performance. not to mention setting up your db like this will make
searching
for individual artists / titles whatever, easier... as you will only
have to reference 1 or 2 columns, and not 20 or 40 per row looking for
a particular artist and / or title.....
Hope this helps.... I know I gave you more theory than code, but this
should get your going in the right direction.
--
---
eric marden
http://xentek.net
---
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
