Hello,
could you please help me figure out why selecting all works but not individual columns? When selecting individual columns I get an empty result set.
Code is below.

I greatly appreciate the help, i have been looking at this for hours.

PHP Code:
function getBookReviews($connection)
{
        
//works
        
$sql="SELECT * FROM theDatabase Where isbn = " $_POST['isbn'];

        
//returns empty set
    //$sql="SELECT index, parent, user, primary, review, spoilers FROM theDatabase Where isbn = " . $_POST['isbn'];

    
$result mysql_query($sql$connection);
    
$reviews = array();
    
    while (
$row mysql_fetch_array($result))
    {
        
$review['index'] = $row['index'];
        
$review['parent'] = $row['parent'];
        
$review['user'] = $row['user'];
        
$review['primary'] = $row['primary'];
        
$review['review'] = $row['review'];
        
$review['spoilers'] = $row['spoilers'];
    
        
array_push($reviews,$review);
    }
        
    echo 
json_encode($reviews);
            
    
mysql_free_result($result);