[PHP-DB] substring_index Part 2

2001-04-12 Thread Mike Baerwolf
Thanks for the help on the earlier ?. Now that I have the select statement working I can't get any results displayed. $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM news",$db) or die ("Invalid Query"); if ($myrow = mysql_fetch_array($result)) { do {

Re: [PHP-DB] substring_index Part 2

2001-04-12 Thread Paul Burney
on 4/12/01 9:53 AM, Mike Baerwolf ([EMAIL PROTECTED]) wrote: $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM news",$db) or die ("Invalid Query"); if ($myrow = mysql_fetch_array($result)) { do { printf("%s\nbr", $myrow["headline"]); printf("%s\n", $myrow["body"]);