Alright, here is a copy of the code that is having the problems:
Code:
<dl>
<dt>
<a onclick="switchmenu('first');" class="proftop" style="cursor:pointer;">
<img src="images/firstmenu.gif" />
<?php $cat1maxlvl = $maxlvl / 4;
?>
<span class="proftop"> <?php echo $faction; ?> <?php echo "$minlvl - $cat1maxlvl"; ?> Profiles</span>
</a>
</dt>
<dd id="first">
<?php
$get1 = "SELECT * FROM `profile` WHERE `minlvl`>='$minlvl' AND `maxlvl`<='$cat1maxlvl' AND `faction`='$faction' ORDER BY profileid AND minlvl DESC";
$q1 = mysql_query($get1) or die(mysql_error());
while($r1 = mysql_fetch_array($q1)){
$p1id = $r1['profileid'];
$p1name = $r1['profilename'];
$p1link = $r1['profilelink'];
?>
<a href="<?php echo $p1link; ?>" class="f1"> <img src="images/profilemenu.gif" border="0" /></a>
<a href="<?php echo $p1link; ?>" class="f1"><?php echo $p1name; ?></a>
<br />
<?php } ?>
</dd>
</dl>
This part of the code is giving me a headache. Here are the variables used in this:
Code:
$minlvl = 1
$maxlvl = 20
$cat1maxlvl = 5
$faction = alliance
and then so on and so forth.
I have 4 of these being called as it runs down the script, going from levels 1-5, 5-10, 10-15, and 15-20. The thing is, this one is getting something that has a maxlvl of 10. Is my SQL wrong? If you need to see the full script just let me know.
Thanks.