$value = preg_replace('/[\r\n]+/', '\n', $value);
echo htmlentities($value);
$sql_export = "SELECT * INTO OUTFILE 'tables.txt' FROM `table_name` ";//var_dump($sql_export);if($result = mysql_query($sql_export))echo "Recorded";else echo "Not recorded";
If you have the “yoo_tweet module” installed, disable this module as well. This module is known to display this error message.
Because this module load feed data with link http://feeds.joomla.org/JoomlaSecurityNews, this link is broken, so it pop up a error loading feed data error.
SELECT TIME_TO_SEC(TIMEDIFF(NOW(),`field_name`));between 2 mysql fields can look like this:
SELECT TIME_TO_SEC(TIMEDIFF(`field_name1`,`field_name2`));
¢ – cent £ – pound ¤ – currency ¥ – yen € – euro sign § – section © – copyright ® – registered trademark ™ – trademark ° – degree – e.g. 45° ¹ – superscript 1 ² – superscript 2 ³ – superscript 3 · – middle dot ¸ – spacing cedilla ¼ – fraction 1/4 ½ – fraction 1/2 ¾ – fraction 3/4 ¿ – inverted question mark × – multiplication ÷ – division • – bullet = black small circle ◊ – lozenge ℠ – Service Mark ✓ – check mark ✔ – heavy check mark ✕ – multiplication sign ✖ – heavy multiplication sign ✗ – ballot ✘ – heavy ballot ✝ – Latin Roman Cross ✞ – Latin Cross 3D shadow ✟ – Latin Cross outline ✠ – Maltese Cross ✡ – Star of David ❛ – quotation mark single turned comma ❜ – quotation mark single comma ❝ – quotation mark double turned comma ❞ – quotation mark double comma | ℃ – Celsius ℅ – care of ℉ – Farenheit № – numero symbol – number sign ℗ – Sound Recording Copyright ℞ – Prescription Take pharmaceutical symbol Ω – Ohm ℧ – Inverted Ohm ☀ – sunshine – sun ☁ – cloudy – cloud – dark cloud ☂ – raining – rain – umbrella ☃ – snow – snowman ☄ – shooting star ★ – star solid ☆ – star outline ☇ – lightning ☈ – thunderstorm ☉ – sun ☊ – ascending node ☋ – descending node ☌ – conjunction ☍ – opposition ☎ – phone ☏ – phone symbol outline ☐ – check box ☑ – check box check mark ☒ – ballot box with X ☓ – St. Andrew’s Cross ♔ – White King ♕ – White Queen ♖ – White Rook ♗ – White Bishop ♘ – White Knight ♙ – White Pawn ♚ – Black King ♛ – Black Queen ♜ – Black Rook ♝ – Black Bishop ♞ – Black Knight ♟ – Black Pawn | ☚ – left-pointing index finger ☛ – right-pointing index finger ☜ – left-pointing index finger ☝ – upwards pointing index finger ☞ – right pointing index finger ☟ – downwards pointing index finger ☠ – skull & crossbones ☡ – caution sign ☢ – radioactive sign ☣ – biohazard sign ☮ – peace sign ☯ – yin & yang ☹ – frowning face ☺ – smiley face ☻ – black smiley face ☽ – waxing crescent moon ☾ – waning crescent moon ♈ – Aries ♉ – Taurus ♊ – Gemini ♋ – Cancer ♌ – Leo ♍ – Virgo ♎ – Libra ♏ – Scorpio ♐ – Sagitarius ♑ – Capricorn ♒ – Aquarius ♓ – Pisces | ♠ – black spade suit ♢ – red diamond suit ♣ – black club suit = shamrock ♤ – red spade suit ♥ – black heart suit = valentine ( <3 ) ♦ – black diamond suit ♧ – red club suit ♨ – hot springs ♩ – musical quarter note ♪ – musical eighth note ♫ – musical single bar note ♬ – musical double bar note ♭ – flat note ♮ – natural note ♯ – sharp note ✁ – cut above ✂ – cut here ✃ – cut below ✄ – scissors ✆ – public pay phone ✇ – film reel – tape spool ✈ – airport jet airplane ✉ – envelope mail email ✌ – victory sign ✍ – signature – sign here ✎ – pencil diagonal down ✏ – pencil ✐ – pencil diagonal up |
