Jump to content

PHP and MySQL problem


Recommended Posts

Alright, here is a copy of the code that is having the problems:

<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>
<dd id="first">
$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 } ?>

This part of the code is giving me a headache.  Here are the variables used in this:

$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.

Link to comment
Share on other sites


Since the mins + maxes are integeres, you can try posting them in directs without quotes:

Also, i thing the ORDER clause shouldn't contain an AND (?)

$get1 = "SELECT * FROM `profile` WHERE (minlvl >=$minlvl) AND (maxlvl<=$cat1maxlvl) AND (faction='$faction') ORDER BY profileid, minlvl DESC;";

its also helpful to echo $get1 so you can check that the variables are going in correctly.


Link to comment
Share on other sites

This thread is more than a year old. Are you sure you have something important to add to it?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.