[lppa2004]

Okay why am i getting this error....

Code:

Quotations List Retrieval MySQL Error. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''2005_points' WHERE name LIKE '%Jonathan Selinsky%'' at line 1
Player Name	Date	Time	Rank	Bonus	Total Points

And here is the PHP code
--------------------------------------

PHP Code:

case "view_stats":



                $year = date("Y");

                $table = "$year".'_'.'points';



                echo "<table border=\"0\" cellspacing=\"2\" cellpadding=\"2\">";

                echo "<tr>";

                echo "<th width=\"200\" align=\"left\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">Player Name</font></th>";

                echo "<th width=\"100\" align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">Date</font></th>";

                echo "<th width=\"50\" align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">Time</font></th>";

                echo "<th width=\"50\" align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">Rank</font></th>";

                echo "<th width=\"50\" align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">Bonus</font></th>";

                echo "<th width=\"75\" align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">Total Points</font></th>";

                echo "</tr>";



                $pname = $_GET['name'];



                $result = mysql_query("SELECT * FROM '$table' WHERE name LIKE '%$pname%'") or die("Quotations List Retrieval MySQL Error. " . mysql_error());



                        while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {

                                //$short = substr($row[1], 0, 100);

                                $name = $row["name"];

                                $tdate = $row["date"];

                                $place = $row["place"];

                                $venue = $row["venue"];

                                $ttime = $row["time"];

                                $total = $row["total"];

                                $rank = $row["rank"];

                                $bonus = $row["bonus"];



                            echo "<tr>";

                            echo "<td width=\"200\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">$name</font></td>";

                            echo "<td width=\"100\" align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">$tdate</font></td>";

                            echo "<td width=\"50\" align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">$ttime</font></td>";

                            echo "<td width=\"50\" align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">$place</font></td>";

                            echo "<td width=\"50\" align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">$bonus</font></td>";

                            echo "<td width=\"75\" align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">$total</font></td>";

                            echo "</tr>";

                        }



                echo"</table>";



        break; 

You can see the script in action here -
=====================================
http://lafayettepoker.com/tournament_night/index3.php
------------------------------------------------

[santana]

use $table instead of '$table'

[lppa2004]

okay i tried that earlier and i just tried it again
and i get this msg... yet i know teh database exists

Quotations List Retrieval MySQL Error. No Database Selected

[lppa2004]

as a matter of fact i just tried using the database name itself instead of the variable and get the same error

[lppa2004]

lol.. i forget to uncomment my sql connection include function