Jump to content

[SOLVED] Query


947740

Recommended Posts

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    |      |

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

Link to comment
https://forums.phpfreaks.com/topic/170703-solved-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.