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 ($i16) {
$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; $i4; $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
