title: mysql random number selection error from a table
body: <p>i have a query that runs well on my localhost mysql server, but when i run it on my php script as a query, gets the "random_number" as the query error. I want to select a random     number from 0 to 50 that is not existing in my seat_number table.<br>
      here is my query:
      Does anyone have any ideas?</p>
  
  <pre><code>$result = mysql_query("SELECT FLOOR(RAND() * 50) + 0  AS random_number
  FROM seat_number WHERE "random_number" NOT IN (SELECT Seatno FROM seat_number) ");
  while($row5 = mysql_fetch_array($result)){
              $numQuestion = $row5['random_number'];
         }
  </code></pre>
  
  <p>I have tried with and without "" around random_number, but isn't working.
  Any ideas guys?</p>