[PHP-DB] Do while loop inside of mail()

2006-07-05 Thread Mark Bomgardner 

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';


And the server response
*Parse error*: parse error in */home/Data/email/test.php* on line *28*

Line 28 is the start of the do while loop

markb

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Do while loop inside of mail()

2006-07-05 Thread Bastien Koert 
I don't see you closing the single quote at the end of the statement before 
do loop


Bastien



From: Mark Bomgardner [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Php-Db php-db@lists.php.net
Subject: [PHP-DB] Do while loop inside of mail()
Date: Wed, 05 Jul 2006 16:55:23 -0500

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'].'/tdtd 
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';


And the server response
*Parse error*: parse error in */home/Data/email/test.php* on line *28*

Line 28 is the start of the do while loop

markb

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Do while loop inside of mail()

2006-07-05 Thread Chris 

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