[RESOLVED] MySQL syntax help

[aaronfenker]

$terms = array("", "1020", "1030", "2020", "2030", "3020");

  $year = date('y');
  $next = substr(date('Y')+1,2,2);

  $_1020 = $terms[1] . "-" . $year;

  echo $_1020 . "<br />";

  $query_1020 = "SELECT * FROM {$_1020} WHERE 1";

  echo $query_1020 . "<br />";

  $result_1020 = mysql_query($query_1020) or die("<h2>WTF!</h2>");

My problem is that my query dies. I can't see the error. I'm also really tired. Maybe someone can help my weary eyes. I may figure it out later, but any help anyone can offer would be much appreciated.

[cgraz]

The WHERE clause in your query is useless, and $1020 may be empty.

$query_1020 = "SELECT * FROM $_1020";
print $query_1020;

What's that output?

Also, if you replace "<h2>WTF!</h2>" with mysql_query(), you'll have better luck troubleshooting your query.

[aaronfenker]

I fixed what you said and $_1020 outputs "1020-07"

[Sxooter]

cgraz wrote:

The WHERE clause in your query is useless, and $1020 may be empty.

$query_1020 = "SELECT * FROM $_1020";
print $query_1020;

What's that output?

Also, if you replace "<h2>WTF!</h2>" with mysql_query(), you'll have better luck troubleshooting your query.

I think he meant mysql_error() there by the way...

[cgraz]

whoops...yes I did mean mysql_error() 😃

[aaronfenker]

I figured out the problem. I needed to use a "_" in the table name instead of "-".