I've expirienced the same problem....
And it's not a PHP bug.... no doubt...
here the code
$sql="insert into
login_signup(createdate,logindate,uid,user)values(0,now(),$uid,'$user');";
$res=mysql_query($sql);
if (!file_exists("r1.txt")){
$f=fopen("r1.txt","w");
fwrite($f,"1",1);
fclose($f);
}
else{
$f=fopen("r2.txt","w");
fwrite($f,"1",1);
fclose($f);
}
this sql query make two inserts....
but where are only one file - r1.txt
It seems to be a MySQL bug - and it's only happens with login_signup table - the
other tables works fine...
+------------+--------------+------+-----+---------------------+----------------
+
| Field | Type | Null | Key | Default | Extra
|
+------------+--------------+------+-----+---------------------+----------------
+
| id | mediumint(8) | | PRI | 0 | auto_increment
|
| uid | mediumint(8) | | MUL | 0 |
|
| user | char(40) | | MUL | |
|
| createdate | datetime | | MUL | 0000-00-00 00:00:00 |
|
| logindate | datetime | | MUL | 0000-00-00 00:00:00 |
|
+------------+--------------+------+-----+---------------------+----------------
----- Original Message -----
From: "David Robley" <[EMAIL PROTECTED]>
To: "John (**)" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 5:54 AM
Subject: Re: Insert queries add TWO records to database
> On Thu, 5 Jul 2001 20:22, John (*\*) wrote:
> > I'm not convinced as I have the same problem in Netscape.
> >
> > More likely to be a PHP or MySQL configuration problem as the code is
> > fine. Or maybe IIS?
> >
> > May try it on a different server.
> >
> > Regards,
> >
> > John Stoops
> > Software Engineer
>
> > -----Original Message-----
> > From: David Robley [mailto:[EMAIL PROTECTED]]
> > Sent: 05 July 2001 03:48
> > To: [EMAIL PROTECTED]
> > Subject: Re: Insert queries add TWO records to database
> >
> >
> > On Wed, 4 Jul 2001 21:22, you wrote:
> >
> > I think I saw on the mysql list you had pinned this problem on IE?
>
> OK - for a further diagnostic you could try using the
> mysql_affected_rows() function and echoing that back to the script
> immediately after the insert. That may give a further clue.
>
> I'll have look through the code you sent me off-list and see if there is
> anything else.
>
> --
> David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
> CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
>
> Things working well, no problems. Time to upgrade.
>
> ---------------------------------------------------------------------
> 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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
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
