Printing letters with PHP/MYSQL?

[garfx]

Hey all.

I am looking for a script or software which can produce letters (which can be printed off) using information from my Mysql database. I.e. something that would use a template I have designed and print of a letter to each individual in my database – pulling out information like name and address, username and password.

[Houdini]

All you need to do is a database query that fetches the name address username and password of your users. The sql would look like SELECT name, address, username, password FROM tablename and then out put that information in a form that you wish, then click the printer icon or File->Print.

[garfx]

thanks wouln't that only print of the one letter i need all multimple letters printed off.

[MarkR]

Probably your best bet is to create a single html document containing all the letters. The user may need to adjust the browser print settings (to avoid page numbers, url etc, appearing).

You can use print css styles to affect where page breaks are, so one is printed per page.

Mark

[Houdini]

To see all in the table use something like;

$result = mysql_query("SELECT  name,address,username,password FROM tablename", $connection);
while (list($name,$address,$username,$password) = mysql_fetch_row($result)) {
   echo " <tr>\n" .
         "  <td>$name</a></td>\n" .
         "  <td>$address</td>\n" .
         "  <td>$username</td>\n" .
         "  <td>$password</td>\n" .
         " </tr>\n";
}

If you have one or 100 rows of data that will present them in a table with a new row for each entry in the table.