I have an informix database with a table called phptesttable. It has a
SERIAL field (for mysql users that can help, its the same as INT NOT NULL
PRIMARY KEY AUTO_INCREMENT) and a CHAR field (CHAR in Informix is the
same as VARCHAR in mysql).
In my PHP script if I submit an array and then insert all the data by
looping through with for loop to INSERT all the data from the array my the
value it inserts is empty. For example I have:
INSERT INTO phptesttable (textname) VALUES ('$statement[$counter]')
but when I echo $querya it shows:
INSERT INTO phptesttable (textname) VALUES ('')
It should show the value of the $statement[$counter] that I am looping
through. But as above you can see the value is empty, but when I echo
$statement[$counter] and $counter, they are shown correctly:
the counter is set to 1
the statement is testing this field
So it should echo INSERT INTO phptesttable (textname) VALUES ('testing
this field' but obviously it is not.
When I change the query to not use an array and only insert one variable:
INSERT INTO phptesttable (textname) VALUES ('$statement')
it echos and inserts correctly. So my question is, is it legal to loop
through an array and insert the array $statement[$counter]? I am at a
loss as to what is happening, because if I change the form to submit one
variable instead of an array, it works fine. Any idea as to what is
happening?
Adam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
