ID: 22363 Updated by: [EMAIL PROTECTED] Reported By: georgehubert3 at hotmail dot com -Status: Feedback +Status: Bogus Bug Type: MySQL related Operating System: FreeBSD 4.7-RELEASE #0 PHP Version: 4.3.1 New Comment:
changed status to bogus Previous Comments: ------------------------------------------------------------------------ [2003-02-23 02:16:42] [EMAIL PROTECTED] This has been reported many times and always it has been broken HTML that causes the page to be loaded twice. So check this first. ------------------------------------------------------------------------ [2003-02-22 03:46:27] [EMAIL PROTECTED] Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. Could you add a SHORT testcase please, including table definition. ------------------------------------------------------------------------ [2003-02-21 15:10:37] georgehubert3 at hotmail dot com The Odd/Even info does not happen 100%. Two rows are always added to the table. ------------------------------------------------------------------------ [2003-02-21 15:05:06] georgehubert3 at hotmail dot com Trying to insert data from a posted form into mysql 3.23.42 creates a blank record and then the correct record (2 records total). Only happens if number of records in table is even (i.e. 2 records, 4 records, etc.). If number of records in database is odd then the query correctly inserts only one record. I can reproduce this 100%. Contact me to see it in action and view scripts. $query = "INSERT INTO Ads SET CompanyName = '$CompanyName', WebSite = '$WebSite', Text = '$Text', StartDate = '$StartDate', EndDate = '$EndDate', Notes = '$Notes', Extension = '$Extension'"; $result = mysql_query($query); Compiled Options: './configure' '--with-apxs=/hsphere/shared/apache/bin/apxs' '--with-zip' '--with-bz2' '--with-zlib-dir' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr/local' '--with-gd=/hsphere/shared' '--with-mysql=/usr/local' '--with-gettext=/usr/local' '--disable-debug' '--enable-versioning' '--enable-sockets' '--enable-track-vars' '--with-imap=/hsphere/shared' '--with-pgsql=/usr/local' '--enable-ftp' '--localstatedir=/var/hsphere/php' '--enable-trans-sid' '--without-curl' '--with-mcrypt' '--with-dom' ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=22363&edit=1