padams Posted May 23, 2008 Share Posted May 23, 2008 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? Link to comment https://forums.phpfreaks.com/topic/106874-problems-inserting-records-into-mysql/ Share on other sites More sharing options...
Barand Posted May 23, 2008 Share Posted May 23, 2008 Sounds like the variable that you are trying to insert into that field is an array. Link to comment https://forums.phpfreaks.com/topic/106874-problems-inserting-records-into-mysql/#findComment-547927 Share on other sites More sharing options...
padams Posted May 25, 2008 Author Share Posted May 25, 2008 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. Link to comment https://forums.phpfreaks.com/topic/106874-problems-inserting-records-into-mysql/#findComment-549814 Share on other sites More sharing options...
fenway Posted May 29, 2008 Share Posted May 29, 2008 "Array" is coming from php as the object type... so you *are* trying to insert an array. Link to comment https://forums.phpfreaks.com/topic/106874-problems-inserting-records-into-mysql/#findComment-552673 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.