Re: [PHP-DB] substring_index Part 2

2001-04-12 Thread Ron Brogden
At 11:53 AM 4/12/2001 -0500, you wrote: >Thanks for the help on the earlier ?. Now that I have the select statement >working I can't get any results displayed. You can't print what you haven't asked for. > $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM > news",$db) or die

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\n", $myrow["headline"]); > printf("%s\n", $myrow["body"])

[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 {