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 = "tom-dugan"
Tom Dugan : 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 (57,180,252,322,405,410,454,503,674,692,715,805,1030,1114,1117,1174,1198,1299,1404,1447,1479,1482,1491,1518,1696,1916,2051,2090,2176,2183,2206,2267,2855,2890,2992,3016,3040,3046,3153,3158,3159,3164,3283,3352,3440,4081,4117,4207,4221,4314,4420,4492,4513,4748,4823,4848,5149,5167,5207,5209,5222,5321,5821,5846,6013,6089,6289,6322,6478,6507,6540,6600,6863,6934,6969,7088,7270,7643,7646,7749,7756,8024,8038,8054,8088,8146,8149,8158,8515,8524,8574,8733,8994,9203,9989,9990,9991,10300,10642,10926,10928,11026,12386,12571,13550,13626,13797,14003,14144,15121,15513,15636,15755,15816,16108,16138,16147,16410,16936,16952,17029,17724,18225,19143,19144,19147,19149,19627,19631,19769,19773,19982,20521,20524,21817,21902,21951,21998,22074,22245,22378,22404,22405,22791,22942,23056,23095,23106,23132,23293,23373,23498,23518,23524,23964,23968,23981,24039,24040,24344,24351,24352,24355,24382,24435,24461,24516,24583,24629,24679,24686,24718,24906,25118,25151,25155,25387,25959,25999,26701,27213,27214,27769,27836,28047,28058,28915,29070,29088,) and agatti_films.active=1