Re: Trying to add table prefix variable to query (solved)
| From: | Verdon Vaillancourt | Date: | Tue, 10 Sep 2002 13:51:00 +0000 |
| Subject: | Re: Trying to add table prefix variable to query (solved) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-115849@lists.php.net to get a copy of this message | ||
Doh,... Thanks to all who replied so promptly with similar answers.
:) vern
On 9/10/02 9:13 AM, "Jacob Miller" <jacob@emprisecorporation.com> wrote:
> Make sure you don't have a space before the 2nd half of the table name
>
> Wrong:
>
> .. "FROM " . $table_prefix . " teams"
>
> this will produce "FROM ccl_ teams"
>
> Right:
>
> .. "FROM " . $table_prefix . "teams"
>
> this will product "FROM cc_teams"
>
> - jacob