Help me with this code. im new :)

[mailliw17]

what is wrong in this code?
it doesnt work. even if i have 3 -> ;;; in my database. what is wrong with the explode code?

<?php

######## \\
##  page_badges.php 
######## //

include('control.php');

echo "Here you can see all badges you have.<br>";
echo "Click on a badge to set is as your current badge.<br><br>";

$sql = mysql_query("SELECT badges FROM users WHERE name='".$_SESSION['name']."'");
$sql = mysql_fetch_array($sql);
$badges = $sql['badges'];

$badge = explode(";", $badges);
$badges_num = count($badge);
$badges_num--;
$i = 0;

			if($badge[0] == ""){
				echo "You dont have a badge.<br>";
				include('stats.php');
				include('footer.php');
				exit();
			}

	echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"100%\">";
	while($badges_num > $i){

	?>

	  <tr>
    <td width="16%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="16%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
  </tr>

[mailliw17]

what's wrong with the code? reply guys..

[anakadote]

it doesnt work.

What, exactly, doesn't work?

[bradgrafelman]

Any error messages? If no, did you check to see if display_errors is set to On and error_reporting set to E_ALL?

[Weedpacket]

As well as repeating the call for a description of the symptoms, I add that needing to do this at all with the result of a database query is a red flag suggesting the database's design may be poor.

[mailliw17]

help me please 🙁

[Weedpacket]

You've already had three replies.

[halojoy]

the while loop
I would do differently.
It might work, but it doesnt look good to me.
Should be possible to simplify.

        while($badges_num > $i){

    ?>

      <tr>

<td width="16%">
<?php 

echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 
src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; 
$i++; 
if($i == $badges_num){ break; }

?>
</td>

    <td width="16%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
  </tr>

}

[mailliw17]

still no sign of work 🙁 let me give you the full code

<?php

######## \\
##  page_badges.php 
######## //

include('control.php');

echo "Here you can see all badges you have.<br>";
echo "Click on a badge to set is as your current badge.<br><br>";

$sql = mysql_query("SELECT badges FROM users WHERE name='".$_SESSION['name']."'");
$sql = mysql_fetch_array($sql);
$badges = $sql['badges'];

$badge = explode(";", $badges);
$badges_num = count($badge);
$badges_num--;
$i = 0;

			if($badge[0] == ""){
				echo "You dont have a badge.<br>";
				include('stats.php');
				include('footer.php');
				exit();
			}

	echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"100%\">";
	while($badges_num > $i){

	?>

	  <tr>
    <td width="16%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="16%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
    <td width="17%"><?php echo "<a href=\"?act=badge_general&setID=".$i."\"><img border=0 src=\"img/badges/".$badge[$i].".gif\" width=50 height=50></a>"; $i++; if($i == $badges_num){ break; } ?></td>
  </tr>

[laserlight]

You still have not answered the question: how does what not work?

[mailliw17]

even if i have 3 badges it still shows i dont have any badge 🙁 it shows 0 badge.

[mailliw17]

help me please guys 🙁

[bradgrafelman]

Try echo'ing out the query string and pasting it into something like phpMyAdmin to see if any rows are returned.