On Tuesday, Oct 28, 2003, at 15:19 Africa/Accra, Erich C. Beyrent wrote:
Hey folks,...
I am having a dreadful problem here, and I cannot get to the root of it. It
appears that every time I do an INSERT, the insert happens twice. I have
spent several days on Google, but with no luck.
Some background - I am using PHP and Smarty on a site. Here is one of the
tables in my database that is having the problem:
$sql = "insert into composers(ComposerFname, ComposerLname) values('', 'Bach')";
which then gets executed. My debug statements indicate that this is only
getting executed once. However, I end up with two new entries in my
composers table. I know I can solve this by making the fields unique, but
I'd have to do that for every table in the database, when what I'd really
like to do is find out why the insert is happening twice.
Any ideas?
Test the query in the MySQL command line client to see if you experience the same behavior outside of PHP.
Cheers! --zak
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
