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.
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);
}