$HTTP_POST_VARS['middlecasts']['key']['subkey']['wecould']['go_on']['forver'];

;)

Mike



Ian Evans wrote:

>My mind is going blank here and I feel like I'm missing something basic.
>
>I have an insert form for movie profiles that takes cast members, writers and 
>directors and inserts them into the 
>tables for the correct movieid.
>
>In the old version of the script I would repeat the inserting section of the code 
>three times, once for casts, 
>once for directors and once for writers. The script checks if the person's 
>first/middle/last name exists in the
>people table. If it does it grabs the id number, if it doesn't it doesn't it inserts 
>it and gets the id number.
>The peopleid and titleid are then inserted into the appropriate table. (casts, 
>writers, directors)
>
>I decided to streamline the code with a function so that calling 
>peopleinserter($table,$titleid) would loop
>through the form variables and insert into the appropriate table. I can easily grab 
>the results of the 
>$HTTP_POST_VARS but I'm going blank trying to get the array out of the array.
>
>Here's a snippet:
>function peopleinserter ($table,$titleid) {
>//$titleid = the titleid from the titles table
>//$table = the job table e.g. casts, directors, writers
>global $HTTP_POST_VARS;
>$firstvar = "first$table"; //if $table = casts it would grab the firstcasts variables 
>from the form
>$middlevar = "middle$table";
>$lastvar = "last$table";
>while (list ($key, $val) = each ($HTTP_POST_VARS[$lastvar])) {
>//in this example $lastvar=lastcasts, so it's calling each 
>($HTTP_POST_VARS[lastcasts])
>// if I echo $key $val for this I would get for example "0 Thornton 1 Jolie
>//end snippet
>
>How do I call the key of the firstcasts, middlecasts, lastcasts arrays so I can do 
>stuff like:
>$lastcasts[$key] = trim($lastcasts[$key]); and
>$sql = "SELECT peopleid, first, middle, last FROM people WHERE 
>first='$firstcasts[$key]' and middle='$middlecasts[$key]' AND 
>last='$lastcasts[$key]]'";
>
>In other words, how do I get those three arrays out of the HTTP_POST_VARS array?
>
>Banging head on desk...
>
>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to