Doh,... Thanks to all who replied so promptly with similar answers.
:) vern
On 9/10/02 9:13 AM, "Jacob Miller" <[EMAIL PROTECTED]> 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
Maybe you should assign the query to is's own value doing your string
concatenation...
i.e.
$query = "select * ...";
then echo out the query:
echo $query;
I think you will see the problem them, I would guess that when you are adding
the table_prefix to the table name that you are getting an e
[snip]
This is my query:
This is my config file:
This is my table name:
ccl_teams
[/snip]
You're query reads like this now
"SELECT * FROM ccl_ teams WHERE username = 'admin'
You need to concatenate the variable with the text (remove the space);
"SELECT * FROM " . $table_prefix . "teams W
This query worked until I tried to add support for a table prefix in the
config file. Now it can¹t seem to find the table. Any pointers to what I am
doing wrong?
Thanks, v
Original query:
This is my query:
This is my config file:
This is my table name:
ccl_teams
This is the error:
Warning
4 matches
Mail list logo
