Rob G wrote:
I'm working on this, and am not sure how the variable syntax needs to be
here.

This is what I have done manually.

//BEGIN EXAMPLE
mysql_query ("INSERT INTO testimonials (id, quote, name) VALUES ('$id_1',
'$entry_1', '$name_1')");

mysql_query ("INSERT INTO testimonials (id, quote, name) VALUES ('$id_2',
'$entry_2', '$name_2')");

mysql_query ("INSERT INTO testimonials (id, quote, name) VALUES ('$id_3',
'$entry_3', '$name_3')");

//BEGIN EXAMPLE
while ($i<16) {
$i++;
mysql_query ("INSERT INTO testimonials (id,quote,name) VALUES ('$id_1',
'$entry_1', '$name_1')");)");

You are looking for variable variables

http://us3.php.net/manual/en/language.variables.variable.php

example of what is going on.

<?php

# Variable Variables Test

$id_0 = 'zero';
$id_1 = 'one';
$id_2 = 'two';
$id_3 = 'three';

for ( $i=0; $i<4; $i++ ) {
        echo ${'id_'.$i};
}

?>

So, for what you are wanting to do. I would do something like this.

<?php

#
# Your other code here
#

for ( $i=1; $i<=16; $i++ ) {

        $SQL = "INSERT INTO testimonials (id,quote,name)
            VALUES (
                 '".${'id_'.$i}."',
                 '".${'entry_'.$i}."',
                 '".${'name_'.$i}."'
                )
              ";

        echo $SQL;

#        mysql_query ( $SQL );

}

?>

}
//END EXAMPLE


What I'm trying to figure out, is exactly how I need to format my entry
within the VALUES section, so that it will change based on the value of $i.

--
Jim Lucas

   "Some men are born to greatness, some achieve greatness,
       and some have greatness thrust upon them."

Twelfth Night, Act II, Scene V
    by William Shakespeare

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to