Re: [PHP-DB] Sql result loop problem !

2001-05-18 Thread Jason Stechschulte
On Fri, May 18, 2001 at 04:32:51PM +0200, Keith Whyman wrote: > while ($p = mysql_fetch_array($result1)) { > > $msg .= $p["s_bereich_name"]; > $msg .= $p["s_news_text"]; > $msg .= $p["s_users_real_name"]; I'm not sure if this is what you want, but something like this maybe?? \n"; $oldBere

[PHP-DB] Sql result loop problem !

2001-05-18 Thread Keith Whyman
I know someone can help ! Following sql SELECT DISTINCT s_news_text,s_bereich_name,s_users_real_name,s_bereich_id FROM s_news,s_users,s_bereich WHERE (s_news_user_id = s_users_user_id) AND (s_news_bereich_id = s_bereich_id) AND (s_news_sent ='0') ORDER BY s_bereich_name while ($p = mysql_fetch_