[SOLVED] MySQL number Inserting

[cheechm]

Hi,

I am trying to insert a number starting with a zero into a MySQL table, however the 0 is always taken off. I tried all of the int types.

What is wrong?

$sql = "UPDATE customers SET telephone = '07798494825';

Thanks

[Barand]

store it as varchar, not as a number. A phone number is just a string that happens to contain numeric characters

[cheechm]

Thanks but now this:

 

UPDATE customers SET `number` = '07894512345' AND address = 'London' AND email = '[email protected]' AND name = 'Nick' AND postcode = 'WE1 3SW' AND company = 'Design' WHERE cid = 4

 

It sets number as 1?

what!!

 

Number = varchar(40) latin1_swedish_ci

 

Thanks so far!

[kenrbnsn]

You don't want to use "AND" like that. If you are setting more than one column separate them with commas:

UPDATE customers SET `number` = '07894512345', address = 'London', email = '[email protected]', name = 'Nick', postcode = 'WE1 3SW' 

 

Ken

[Barand]

That's because you are setting to the result of a boolean expression with those ANDs. Correct syntax is

 

UPDATE customers SET

    `number` = '07894512345',

    address = 'London',

    email = '[email protected]',

    name = 'Nick',

    postcode = 'WE1 3SW',

    company = 'Design'

WHERE cid = 4

[cheechm]

Excellent.. All fixed up! Thanks for quick repplies.

 

Nick

[PFMaBiSmAd]

Edit, third explanation -

 

AND is a logical operator. `number` is being set to all the true/false results of the expressions (which are all true), resulting in a true (1) value.

[Barand]

That was my (second) explanation - boolean expression