Re^2: MySQL question

Thanks to all above. The shortened script works. Will now be updating the larger read and insert script and am crossing my fingers.
I had read the documentation on placeholders but was not keen on their use.
Thank you for the direct examples, they now make sense.

Comment on Re^2: MySQL question

Replies are listed 'Best First'.
Re^3: MySQL question by lostjimmy (Chaplain) on Nov 28, 2008 at 15:07 UTC
In addition to what everyone else has said, placeholders are also good for performance. Instead of preparing the same statement handle over and over again (when inserting multiple rows), it only needs to be done once. They also make the code a lot cleaner, making it more obvious which values are supplied and which are static.	[reply]