[RESOLVED] Exporting to Word

netfrugal

I am actually successful with exporting to a word RTF template. I simply use the str_replace() function to populate whatever from the database.

But I've only been able to figure out how to populate individual records, not arrays.

If I have this query:

$sql = "SELECT * FROM books";
$result = mysql_query($sql);
   while($row = mysql_fetch_assoc($result)){

 $book_titles = $row['book_titles'];

}

How do I put all titles inside one variable? Otherwise, I'm only getting one title, which is the last in the table.

netfrugal

Okay, I've figured out how to put all data into an array of some sort:

$sql = "SELECT * FROM books";
$result = mysql_query($sql);
   while($row = mysql_fetch_assoc($result)){

 $book_titles .= $row['book_titles'] . "<br>";

}

I added the .= and it seems to be working find.

Except for one thing, I can't seem to get any in the rtf document.

The rtf document shows the results as this:

Tom Sawyer How to kill a mockingbird The Jury

Any thoughts on how to take out the tags, but be able make them work?

netfrugal

Guess I found it!

I have to put ' \par' in place of for the rtf to understand when to make a break in a line.

Just syntax stuff.