Hey PHP People! menu

User Tag List

Results 1 to 1 of 1
  1. #1
    Tory's Avatar Contributor
    Reputation
    161
    Join Date
    May 2006
    Posts
    300
    Thanks G/R
    19/11
    Trade Feedback
    2 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Hey PHP People!

    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.
    [RETIRED] MMOwned.com Co-Founder & Developer

    Hey PHP People!

Similar Threads

  1. [Misc] Hello there people server wowlava is looking for some one with php language
    By marsa in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 11-13-2010, 12:24 PM
  2. Paypal - How to win unauthorized claims [PHP people look]
    By Kεяusнιι in forum WoW Scams Help
    Replies: 5
    Last Post: 03-09-2009, 06:54 AM
  3. Hey people, i think I have a slight problem.
    By Fietsslot in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 04-18-2008, 08:18 PM
  4. Replies: 11
    Last Post: 01-10-2008, 10:07 PM
All times are GMT -5. The time now is 02:24 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search