where is my data?

[naghme]

hi,
i have a funny problem and i dont know where it comes from,
i wanted to have the max field of a table (this field is date ) and every day the date of a system is inserted in to this table, when i select max of this field i receive 2003-18-03 , i dont know why, today is 2003-10-05 ,i have seleceted all records to see what happens and i saw that only records before 2003-18-03 are available and when i look up in the database and run the script in the local machine every thing is ok and there are records till today.

any idea?
thank you
naghmeh

[jatar_k]

Welcome to WebmasterWorld naghme,

what does the query look like in the script?

You said that when you run it on localhost it is fine but not on the server? have you compared data on the server then? Can you log into mysql directly via ssh or something and test your queries there and take a look at what actually is in the table?

[naghme]

thank you,
well,i am sure about data because when i want to test them i upload the file manualy or download the file on the server to my local computer and check data and test my script with the file which is on the server, but it does not work.i even changed the name of table,field and data type but when i change them i get such an error :

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'naghmeh'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect

i thought may be it comes from cach but in other scripts when i run them i get the data which is exactly in the test file i have uploaded so it comes exactly from the file but i dont understand why it dose not recognize this table?

i am realy getting mad of this ridiculous problem
any help or suggestion is realy appreciable
naghme