Okay, so I did some detective work and found the problem. I thought you
might want to know the cause.
I use Textpad as my HTML editor right now, and when you create an HTML file
from scratch, it has the following <BODY> tag:
<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#800000"
ALINK="#FF00FF" BACKGROUND="?">
The BACKGROUND="?" part was causing the problem. When I remove ONLY that
part of the body tag, the duplication problem went away.
----- Original Message -----
From: "Eddie Heard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 20, 2001 12:05 AM
Subject: Duplicate Inserts
> I'm running MySQL on a WIN2k server box. I'm doing inserts using PHP.
> Here's the code for the insert:
>
> $db = mysql_connect($hostname, $uid, $pwd); //$hostname is "localhost"
and
> $uid/$pwd are userid and password
> mysql_select_db("heroes",$db);
>
> $insertQuery = "INSERT INTO UniqueCardList (MCardID,OwnerID)
VALUES(1,1)";
> echo $insertQuery . "<BR>\n";
> $insertResult = mysql_query($insertQuery,$db)
> or die ("Insert query failed");
>
> I can go in, delete all records from the table, run the code once, and
wind
> up with two records.
>
> Anybody got any ideas?
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
