Can't Use Variables in mysql_query()?
===

This is about as basic as it gets guys and girls.

I have a very simple script that just will not work.  I call the database and test it's connection, I do a query, store the result, and print the result.

The problem is that I can't seem to use any variables in my SQL statement.  

Here's the code:

    <?php
    
        $rest_name = $_GET['rest_name']; // outputs 'Starbucks'
    	
        $test = mysql_query("SELECT code_id FROM table_code WHERE restaurant = '$rest_name'");
    	
        /* I've also tried these as well
        $test = mysql_query("SELECT code_id FROM table_code WHERE restaurant = '".$rest_name."'");
        */

        $mark = mysql_result($test,0);
    	
        echo $_GET['rest_name'].$mark; 
    ?>

I echoed the query and it looks fine and run fine in the database.  The $rest_name variable echos fine.  The $_GET['rest_name'] echos fine.  I am lost and confused on this.