select *, DATE_FORMAT(birthday, "%b %e, %Y") as _birthday, DATE_FORMAT(died, "%b %e, %Y") as _died, MONTH(birthday) as month_birth, DAY(birthday) as day_birth, DATE_FORMAT(birthday, "%b %e") as _birth_day_month from agatti_people where agatti_people.u_name = "dennis-o-keefe"
Dennis O'Keefe : Classic Movie Hub (CMH)
Classic Movie Hub (CMH)
 
 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and agatti_films.active=1' at line 1
select agatti_films.genre1,agatti_films.genre2,agatti_films.genre3,agatti_films.genre4,agatti_films.genre5,agatti_films.genre6,agatti_films.genre7,agatti_films.genre8,agatti_films.genre9,agatti_films.genre10 from agatti_films where id in (15,34,35,62,68,175,184,231,269,301,416,424,448,466,598,680,691,768,1063,1078,1163,1171,1181,1192,1276,1363,1375,1381,1478,1480,1498,1538,1651,1937,2049,2050,2177,2202,2206,2381,2404,2590,2661,2855,2969,3020,3048,3056,3061,3062,3065,3167,3169,3175,3418,3436,3654,3800,4082,4083,4085,4150,4155,4176,4379,4395,4401,4408,4488,4751,5089,5093,5163,5233,5262,5481,5485,5736,6162,6172,6174,6282,6647,6832,6951,6967,7037,7044,7622,7623,7641,7700,7859,7956,8162,8180,8226,8367,8440,8604,8912,9088,9833,9933,9986,10112,10926,11409,12233,12899,12945,13180,13318,13623,13993,14029,14488,15002,16087,16095,16608,17254,17559,17567,17571,18132,18297,18301,19159,19389,19391,19395,19465,19632,19779,19918,19976,21067,21824,21855,22146,22165,22320,22396,22398,22426,22536,22559,22632,22721,22731,22739,22768,22774,22945,23200,23264,23287,23293,23346,23496,23502,23505,23595,23642,23830,23834,23835,24043,24348,24357,24382,24383,24390,24551,24580,24583,24636,25952,25993,26255,26256,26306,26424,27646,27786,28404,29085,29101,29244,30831,32526,) and agatti_films.active=1