 |
 |
Find a programming school near you
php-db | 2001041
Date: 04/12/01
- Next message: franky: "[PHP-DB] add php to apache"
- Previous message: B. van Ouwerkerk: "Re: [PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()"
- In reply to: Mike Baerwolf: "[PHP-DB] substring_index Part 2"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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: support <email protected>
Canada WWW: http://www.islandnet.com/
-----------------------------------------------------------------------------
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: franky: "[PHP-DB] add php to apache"
- Previous message: B. van Ouwerkerk: "Re: [PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()"
- In reply to: Mike Baerwolf: "[PHP-DB] substring_index Part 2"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
