Re: Trying to add table prefix variable to query

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... >