Problems inserting records into mySQL

[padams]

I've had a problem with mySQL recently. When inserting data (using either SQL or the phpMyAdmin interface) into a table, the data in the second field changes to the word 'Array'. Doesn't happen all the time, but certainly at least 90% of the time.

 

If it matters, there are four fields, called 'personID' (int), 'firstName' (varchar), 'lastName' (varchar), and 'job' (varchar).

 

We're running mySQL version 5.0.18, and phpMyAdmin version 2.8.0.3.

 

Any ideas?

[Barand]

Sounds like the variable that you are trying to insert into that field is an array.

[padams]

NO, not an array. Just text. For example, a couple of the rows are:

1, Phil, Adams, Teacher

2, Bill, Clarke, Teacher

 

When entered, both first names changed to Array.

 

Additionally, I added an extra column called 'photo'. I entered data in there, file names such as philadams.jpg and billclarke.jpg. Then, when I changed the first names back to Phil and Bill, both photos had changed to Array. When I try to change them phpMyAdmin says 'No Change' and won't change them.

[fenway]

"Array" is coming from php as the object type... so you *are* trying to insert an array.