duplicate entries with random numbers

LordRogaine

I'm having a unique problem I have never seen before. I'm using php with mysql. I have a messaging system I created on my website where the members communicate with eachother. Information for each message is placed in the database. The problem I am having is that every now and then there will be duplicate information inserted into the database and with it random numbers. An example would be--- inserting the name "JoeSmith" and then I would find a duplicate entry, but like this "JoeSmith08cbac8c". This does not happen all the time but I would like to eliminate it from happening. Has anyone heard of this before and know why it happens?

Thanks in advance,
LordRogaine (no, rogaine has not helped)

thorpe

Can we see some code. It looks like your user names might be getting stored with there session id's somehow appended to them.

Its really a bit hard to tell whats going on without some code.

LordRogaine

I'm using very basic code- here it is. The unusual part is that the random numbers are always no less or more than a total of eight. The field that is being duplicated is "sentfrom". Thank you for looking.

$query = "insert into mailbox
(userid, sentfrom, sentto, mail_id, subject, message, messagesent)
values ('$userid', '$sentfrom', '$sentto', '$mail_id', '$subject', '$message', now())";

thorpe

That really doesn't help. Can you put this code in context?