I am trying to insert serialize values into ac_services
table but getting error:
syntax error, unexpected T_LNUMBER in C:\wamp\www\db-setup\steps\db-install-script.php on line 559
$insert_ac_services = "
INSERT INTO `ac_services`
( `id` , `name` , `desc` , `duration` , `unit` , `paddingtime` , `cost` , `capacity` , `availability` , `business_id` , `category_id` , `staff_id` )
VALUES
( 1, 'Default', 'this is default service.', 30, 'minute', 10, 15, 1, 'yes', 0, 0, 'a:1:{i:0;s:2:"1";}' ) ;
";
mysql_query($insert_ac_services);
I generated this php query by phpmyadmin. But not working, Any suggestion? Thanks...
You should escape the ".
'a:1:{i:0;s:2:\"1\";}' ) ;