Month: March 2011
-
MySQL: How to delete X day old entries
In some cases we need to remove old entries from the database or remove entries before specific days. So mysql provides the syntax to delete records: DELETE FROM $table_name WHERE $date_field < date_sub(CURDATE(), $numberOfDays day) If above query does not work for you then its version issue. So you can do same thing like this:…
-
Javascipt: how to use nl2br function
In php we have a function to replace nl2br means new line to break format. but when we need this functionality in our javascript code then what we do? We can do by simply manner: function nl2br(value) { return value.replace(/\n, “”); } Above function will return the converted ‘\n’ to ‘‘. But above function has…