I've written a script that adds student data (name and classes) to a table one at a time. The table is structured so that there is a primary key column, a student name column, and then a column for each class. The script checks to see if the class it's adding already exists as a column, and if not it creates it. Then it writes 'true' under that column for the current student.
Here's my problem: from the log file I can see that every single query is sent to MySQL correctly, but some don't show up in the table. When I run these queries (
http://pastebin.com/FuSxm1KA ), the table looks like so:
http://d.pr/i/RrRk
That is, the final query "UPDATE Students SET 3uth1='true' WHERE idStudents='1'" doesn't go through.
I hope this makes sense, and someone can shed some light on this issue - it's driving me crazy.