I would like to insert text into my database so that when the database is queried the text is retrieved just like the way into looks in the word document. Currently when i put the text comes out all squashed up without paragraph, tags or indents.
this is the code i am using at present
If (!empty($POST['resume'])){
$re = escape_data($POST['resume']);
} else {
$re = FALSE;
echo '<p><font color="red" size="+1">Please Include Your CV/Resume!</font></p>';
require('footer.php');
exit();
}
and another thing
this text completely messes up my php generated page when it is retreived why is that so
The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected rows to a file. The file is created on the server host, so you must have the FILE privilege to use this syntax. file_name cannot be an existing file, which among other things prevents files such as /etc/passwd and database tables from being destroyed. As of MySQL 5.0.19, the character_set_filesystem system variable controls the interpretation of the filename.
The SELECT ... INTO OUTFILE statement is intended primarily to let you very quickly dump a table to a text file on the server machine. If you want to create the resulting file on some client host other than the server host, you cannot use SELECT ... INTO OUTFILE. In that case, you should instead use a command such as mysql -e "SELECT ..." > file_name to generate the file on the client host.
SELECT ... INTO OUTFILE is the complement of LOAD DATA INFILE; the syntax for the export_options part of the statement consists of the same FIELDS and LINES clauses that are used with the LOAD DATA INFILE statement. See Section 13.2.5, “LOAD DATA INFILE Syntax”.
