One of my apps in a test enviroment is showing some strange behaviour.
Up-front-answer: No, there are no loops in this segment of code.
Snippet:
$password = sha1(stripslashes($eval['tpassword']));
$query = "INSERT INTO logins (login_parent, login_name, login_password, fname,
lname) values ($id, {$eval['temail']}, '$password', {$eval['fname']},
{$eval['lname']})";
doDebug(7, "SQL: $query");
$r = $db->query($query);
errorCheck($r, $db);
doDebug is a custom logging command. errorCheck is a wrapper to the PEAR
error checking stuff for DB.
Mysql Logs:
40821 Init DB product
40821 Query INSERT INTO logins (login_parent,
login_name, login_password, fname, lname) values (36, '[EMAIL PROTECTED]',
'ef2a9c2c39232fbe4984787b7a81d2faa0df5d9d', 'Name', 'Name')
40821 Init DB product
40821 Query SELECT last_insert_id()
40821 Init DB product
40821 Query INSERT INTO logins (login_parent,
login_name, login_password, fname, lname) values (36, '[EMAIL PROTECTED]',
'ef2a9c2c39232fbe4984787b7a81d2faa0df5d9d', 'Name', 'Name')
There is no repetition of the last_insert_id() query. Server is 4.1 alpha.
This one boggles my mind, as it was working about a week ago on the same
server, and nothing (and I've double checked) has changed in the
configuration of the DB engine or in the PHP code.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
