Recent content by TTA23

SkipVought: When I do F2, I can see the right date in the field, when I press 'Enter', it goes back to the number. anotherhiggins: Tried this, but to no effect. I noticed that any format I want to apply to any cell on this sheet is not working. I will assume that something is 'dead' o this...

It meanS that I already reformated so many times.... but it doesn't do anything. Well, I make it work. How I did iit.... I cut and paste the whole sheet and reinserted in another sheet. By miracle it is OK!!!! I really would like to know why! Thanks for your help, just got luky on my side...

Nothing. If I type someting that looks like a date (ex:05/02/06) it will convert to the number. If I type a number, it keep the number without try to convert to a date in thr uppper windows. I use Excel all the time, but I never had this

Well, I did what you said before and after you told me, but this doen't do anyhing! This is very strange as usually it works without any problems. For now my date 6/22/2007 will only shows as 39255. Whatever I do to it- Custom formatting, date formatting, etc. It will show me the correct date tho.

I have a column with dates. They should show a date formates as 02/03/07, but they show a number such as 345664 (this is not the real corresponding number). If I click on the field the right date will show in the top window, but not in the column field. I went to reset the column formatting, and...

Oh! Thanks for the full sample - i will try this shortly. This PHP is new to me since i only use ASP. Therefore some obvious things are not always obvious. Thanks again

Personnally PHP doesn't give me anything better than I have now. It is just interresting to see how it works, but a lot of work when I do not know all the little ways around.

MSSQL / Pervasive / VMS or DB2. Those are the ones I usually work with. This MYSQL is a first attempt to learn a little PHP

For ex. I have a table with 120 name. I have a query that retrieve all the names(120). I have a While ... statement that shows the name in the browser. Each time if I use the statement mysql_num_rows($result), it will show that I have 120 names, but I only print 119 in the browser. Cannot...

r937- You are right, I just checked that I can use the Limit statement for my other db in ASp. Never have to use it before and I thought this have to do with MySql or PHP. Thanks again.

Thank. I am using ASP, and this is my first using PHP..... and MYSQL

I have a statement : select * from T_Adherent limit 1, 10 where .... It seems to be wrong. Is there a way to have the limit statement followed by a where statement. If not how can I limit the query with a where statement? thanks

I have a select query and I am using the == mysql_num_rows($result) that give a value that is always the number of row I see + 1. How can I correct this? thanks

Thanks

I noticed that when you have a flash design in an HTML page, you need to first click on it to activate buttons and others. If you don't the flash is not responding. Is there a way to avoid this ? Thanks in advance