[SOLVED] Quick Question on For Loop!

[snowman15]

I have no clue why this code isnt working. Check it out.

 

   <?php
		include('db.php'); // ASSUME CONNECTION AND VARIABLES WORK
    $sql = 'SELECT `people` FROM `users` WHERE `user` LIKE CONVERT(_utf8 \''.$_SESSION['user'].'\' USING latin1) COLLATE latin1_swedish_ci';
$result = $db->query($sql);
$row = mysqli_fetch_assoc($result);
for($i==1; $i<=$row['people'];$i++){
  echo'<option>'.$i.'</option>';
  }
 ?>

[lonewolf217]

just a thought, shouldn't it be

for($i=1; $i<=$row['people'];$i++){

 

since you are initially assigning $i equal to 1, you are not trying to do a boolean compare if $i really is 1

[ohdang888]

always use this:

 

$result = $db->query($sql) or die(mysql_error());