TCPDF and listing from mysql table

[tommy2shoes]

Hi

 

I have used TCPDF to generate documents with single values from a mysql table. Now I want to generate a calendar.

I have a table events_pbw which contains (amongst others) the fields id, date and name.

 

I would like to generate a pdf which lists all of the results for entries after a particular date (eg Jan 1st)

 

I have this:

 

// get data from events_pbw table

$result = mysql_query("SELECT  id, date, name

                    FROM events_pbw

                    WHERE `date` > 2011-01-01"

                    ");

 

while($row = mysql_fetch_array($result))

  {

    $appid = $row['id'];

    $date = $row['date'];

    $name = $row['name'];

}

 

But I don't know how to get the full list of results into the pdf. I'm sure this is very easy but I'm not great on php coding!

 

Does anyone have any examples or help they could give me?

 

Many thanks

[tommy2shoes]

Sorry - didn't make it very clear. I have a section in the pdf generation part which is:

$id<br>

$name<br>

$date<br>

 

This only shows up once in the pdf and I want it to repeat to show all relevant values. How do I do that?