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 extra space in
there...
So, try that out, and see if it helps
-Brad
> 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:
> <?php
> ....
> include("config.php");
>
> $open = mysql_pconnect($hostname,$user,$password);
> mysql_select_db("$db",$open);
> $result = mysql("$db","SELECT * FROM teams WHERE username =
> 'admin'");
> $i = 0;
> $total_rows = mysql_numrows($result);
>
> ....
> ?>
>
> This is my query:
> <?php
> ....
> include("config.php");
>
> $open = mysql_pconnect($hostname,$user,$password);
> mysql_select_db("$db",$open);
> $result = mysql("$db","SELECT * FROM " . $table_prefix . " teams
> WHERE username = 'admin'");
> $i = 0;
> $total_rows = mysql_numrows($result);
>
> ....
> ?>
>
> This is my config file:
> <?php
>
> $db = "sports";
> $hostname = "localhost";
> $password = "mypassword";
> $user = "myuser";
> $table_prefix = "ccl_";
>
> ?>
>
> This is my table name:
> ccl_teams
>
> This is the error:
> Warning: Supplied argument is not a valid MySQL result resource in...
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
