mdraft

Thanks for your help. I found that I had missed a "join" command that needed to be changed. Thanks again!

The following is the result given for SHOW TABLES. Thanks for any help you can give me. SQL query  SQL query: SHOW TABLES  [ Edit ] [ Create PHP Code ] [ Refresh ]   Tables_in_m0n_projections  CY All Statistics CY Bye Week CY Players PY All Statistics PY Bye Week PY Players item_table paypal_table

Hello, I'm a newbie to PHP and I'm struggling with making a change to my code. I would like to pull data from a different table in the same database. However, when I change the table reference to the other table (both the old and new tables are valid, existing tables), I get the following error: Unknown table 'CY Players' in field list The following is the beginning of the code. I have highlighted the line that I would like to change from "PY Players" to "CY Players". Any ideas? Thanks! <?php //MODULE exec query (mysql 4.1 is required) // calc limits $in['limitQB'] = $in['teams']*$in['qbs']; $in['limitRB'] = $in['teams']*$in['rbs']; $in['limitWR'] = $in['teams']*$in['wrs']; $in['limitTE'] = $in['teams']*$in['tes']; //  long select $sql=" SELECT `CY All Players Combined Values`.Name, `CY All Players Combined Values`.Team, `CY Bye Week`.Bye, [color=red]`PY Players`.Consistency,[/color] `PY Players`.HC, `PY Players`.Fade, `CY All Players Combined Values`.Pos, `CY All Players Combined Values`.Expr1 AS `Avg Starter`, `CY All Players Combined Values`.Expr2 AS `Min Starter`, `CY All Players Combined Values`.Expr3 AS `StdDev Starter`, `CY Fantasy Pts Sorted`.`Total FP` AS `This Yr Proj`, `CY Fantasy Pts Sorted`.`Total FP`/`PY Fantasy Pts`.`Total FP`*100 AS `% of Last Yr`