June 7, 2012 at 09:52 /
For the MySQL statement: In wordpress don’t ever use mysql_query(). It has a really great mysql class that handles security very good. Google for $wpdb.
I think the problem was to overwrite the $room value. Have renamed it now and this shouldn’t happen anymore. But instead of an additional mysql statement it would be better for you to store the $room value above in another variable as it stores the information you need.