> > From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED] > > Sent: zondag 30 januari 2005 21:31 > > To: mysql@lists.mysql.com > > Subject: disappearing data - please help! > > > > What makes this all the more mysterious is that it happens > > intermittently. Sometimes when the script completes and reports > > success, the record really is there, and sometimes it's not. > > I am going crazy with this. ...snip...
Are you escaping the data you insert? If you have apostrophies eg. "Sheryl's Website", you could have problem if you do not escape special chars. See if it happens with just "aaaaaa" (without the quotes) in all the fields in the record...then try unescaped words with apostrophies. A nasty is case sensitivity. Some MYSQl vers. (esp. unix vers.) install with case sensivity turned on - so make sure all your table names and stuff match case. Par down the PHP or what ever script you're using to the minimum ie. make the test case as blatently simple SQL as possible. Lee -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]