I an trying to retrieve certain rows from the database table character based on the two variables being equal or less than the numbers within the BookID and CharacterID columns in the table.
Make since?
Code: Select all
$GBookID = $HTTP_GET_VARSї'GBookID'];
$GChapterID = $HTTP_GET_VARSї'GChapterID'];
mysql_select_db($database_lexicon, $lexicon);
$query_Characters = "SELECT * FROM `character` WHERE BookID <= $GBookID AND ChapterID <= $GChapterID";
$Characters = mysql_query($query_Characters, $lexicon) or die(mysql_error());
$row_Characters = mysql_fetch_assoc($Characters);
$totalRows_Characters = mysql_num_rows($Characters);