Mark Bomgardner wrote:
MySQL 4.1/PHP 4.2
I am trying to generate a email to send to people with a list of events
happening through out the month.
I am pulling the email addresses from the database with no problem, but
when I put the list of events inside of the mail(), it barks at the do
while statment.
Here is the do while code:
$message='table width=100% border=0
tr class=style2
td width=20% class=style8uProject Number
/u/td
td width=20%ustrongStart Date/strong/u/td
td width=26%ustrongClass/strong/u/td
td width=34%ustrongLocation/strong/u/td
/tr/table
Line 28 'do { .'
tr class=style2
td width=20%
class=style8'.$row_Recordset1['pnumber'].'/td
td width=20%'.date(m/d/Y, strtotime($row_Recordset1['Sdate'])).'/td
td width=26%'.$row_Recordset1['title'].'/td
td width=34%'.$row_Recordset1['location'].'/td
/tr'. while } $row_Recordset1 =
mysql_fetch_assoc($Recordset1)).'/table';
Before anything else, a helpful hint. Make your code cleaner, it will
be easier to work out whats going on:
$message= '
table width=100% border=0
tr class=style2
td width=20% class=style8uProject Number/u/td
td width=20%ustrongStart Date/strong/u/td
td width=26%ustrongClass/strong/u/td
td width=34%ustrongLocation/strong/u/td
/tr
/table';
do {
$message .= 'tr class=style2
td width=20%
class=style8'.$row_Recordset1['pnumber'].'/td
td width=20%'.date(m/d/Y,
strtotime($row_Recordset1['Sdate'])).'/td
td width=26%'.$row_Recordset1['title'].'/td
td width=34%'.$row_Recordset1['location'].'/td
/tr';
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$message .= '/table';
which one is easier to read and debug?
--
Postgresql php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php