missing 0 on phone/mobile number

[buzzby]

i have a form with a field called 'phone number' and 'mobile number'. entering the numbers is fine. the form goes off to the database no problem. the problem is that when i view the db file online i see that the 0 is missing on both numbers. how can i rectify this?

[tsinka]

Hi,

what type are the columns in the table of ? If it is one of the integer types you would get the value without the leading 0. You might try to change the type to varchar in this case.

Post some code if that doesn't solve the problem.

Thomas

[buzzby]

thank you very much. it fixed my problem. VARCHAR it is. but why is that? isnt 0 a recognised integer as a starting number?

[buzzby]

anybody know about displaying one record at a time in a table that only has 2 rows (top row for the headers, bottom row for the info) with the use of prev and next buttons?

[bastien]

Post1:
Because there is no representation for fixed length numbers, the leading 0 gets dropped.

Post 2:
You can do this simply by using the limit clause in the sql statement

select * from table limit 1

would bring back one row. You can include hidden field to indicate the next row to fetch. Get the field value and use the where clause to get that data from the db