title: PHP/mySQL: mysql_query with SELECT, FROM, and WHERE
body: <p>I am trying to set <code>$nextPageID</code> and <code>$nextPageTitle</code> with the following code. Unfortunately they are not getting set. </p>
  
  <pre><code>$pageCategoryID = 1;
  $nextPageOrder = 2;
  
  $fetchedNextPageData = mysql_query("
    SELECT pageID, pageCategoryID, 'order', title 
    FROM pages 
    WHERE pageCategoryID='$pageCategoryID' AND 'order'='$nextPageOrder'
  ") or die(mysql_error());
  
              while ($nextPageArray = mysql_fetch_array($fetchedNextPageData)) {
                  $nextPageID = $nextPageArray['pageID'];
                  $nextPageTitle = $nextPageArray['title'];
              }
  </code></pre>
  
  <p>My table <code>pages</code> contains a row with pageID = 2, pageCategoryID = 1, order = 2, title = Next Page, plus 4 other columns with data I don't need for this query. </p>
  
  <p>This code has been simplified for testing purposes. It will be sanitized after I get it working.</p>
  
  <p>Any thoughts on what I can do to get this bit of code working?</p>