E-mail verzenden met mysql inhoud
Met dit script toon ik de laatste 20 headlines op mijn site, maar hoe kan ik ze nu ook versturen??
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?
$news=mysql_query("select * from Article order by ArtDate desc limit 19,50");
while($art = mysql_fetch_array($news)){
$art[ArtTitle]=stripslashes($art[ArtTitle]);
$ptime = pretty_time($art[ArtDate],1);
echo "<table><tr><td bgcolor=\"$bgcol\" width=\"1%\" valign=\"top\">•</td><td bgcolor=\"$bgcol\" width=\"99%\" valign=\"top\0\"><a href=$base_url/wmview.php?ArtID=$art[ArtID]>$art[ArtTitle]</a> – <span class=\"date\">$ptime</span></td></tr></table>";
}
mysql_close();?>
$news=mysql_query("select * from Article order by ArtDate desc limit 19,50");
while($art = mysql_fetch_array($news)){
$art[ArtTitle]=stripslashes($art[ArtTitle]);
$ptime = pretty_time($art[ArtDate],1);
echo "<table><tr><td bgcolor=\"$bgcol\" width=\"1%\" valign=\"top\">•</td><td bgcolor=\"$bgcol\" width=\"99%\" valign=\"top\0\"><a href=$base_url/wmview.php?ArtID=$art[ArtID]>$art[ArtTitle]</a> – <span class=\"date\">$ptime</span></td></tr></table>";
}
mysql_close();?>
Ik hoop heel erg op hulp!
