[SOLVED] Query

[947740]

There is something wrong with this query, but I am not sure what it is.  I probably just need some freshe eyes.  Thanks.

 

UPDATE afterschool set `ParentName` = 'Magic Johnson' AND `NumberStudents` = '1' AND `CheckIn` = '1250518740' AND `CheckOut` = '' WHERE ID = 50

 

I get this error: Truncated incorrect DOUBLE value: 'Magic Johnson'

 

The table:

 

+----------------+--------------+------+-----+---------+-------+

| Field          | Type        | Null | Key | Default | Extra |

+----------------+--------------+------+-----+---------+-------+

| ID            | bigint(20)  | NO  | PRI | 0      |      |

| ParentName    | varchar(255) | YES  |    | NULL    |      |

| NumberStudents | varchar(255) | YES  |    | NULL    |      |

| CheckIn        | varchar(255) | YES  |    | NULL    |      |

| CheckOut      | varchar(255) | YES  |    | NULL    |      |

+----------------+--------------+------+-----+---------+-------+

[rhodesa]

Check to make sure you are connecting to the correct database and table, cus that error means you have the datatype of the ParentName field as Double and not Varchar

[947740]

I did this query and it worked.  Huh.

 

UPDATE afterschool set `ParentName` = 'Magic Johnson', `NumberStudents` = '1', `CheckIn` = '1250518740', `CheckOut` = '' WHERE ID = 50

 

Thanks for the help.

[rhodesa]

DUH...how did i miss that...