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 ("Invalid Query");
There is no "headline" or "body" column asked for in the query above. You
would have to add "headline" to the requested columns as well as adding an
"AS something" clause for the substring_index call if you want the
"substring" or the "body" column if you want that.
Cheers,
Ron
-----------------------------------------------------------------------------
Island Net AMT Solutions Group Inc. Telephone: 250 383-0096
1412 Quadra Toll Free: 1 800 331-3055
Victoria, B.C. Fax: 250 383-6698
V8W 2L1 E-Mail: [EMAIL PROTECTED]
Canada WWW: http://www.islandnet.com/
-----------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
