[SOLVED] dynamic list order

[182x]

Hey guys, I was trying to get the list box to display the id numbers in ascending order however the code below does not work, just wondering how to fix it? thanks.

<?php
$g = "SELECT * FROM em ORDER BY iD ASC";
$q = mysql_query($g, $link_id) or die(mysql_error());

if (mysql_num_rows($q) > 0)
{
?>
<select name="d">
<?php
while($r = mysql_fetch_assoc($q))
{
?>
  <option value="<?php echo $r['Id']; ?>"><?php echo $r['Id']; ?></option>
<?php
}
}
?>

[jvrothjr]

is the field name Id or iD

[182x]

sorry that was a typo when changing variables its Id

[jvrothjr]

could be an issue with the field type. Is the field Char or Int

[PC Nerd]

echo "<option value = '".$r['Id']."'>".$r['Id']."</option>\n";

 

i havent a clue what that might do to help, but i know that if i sometimes rewrite my code again, the error disapears.... its really weird

[182x]

could be an issue with the field type. Is the field Char or Int

 

The type is varchar, does that make a difference. I pretty new to all this.

[182x]

echo "<option value = '".$r['Id']."'>".$r['Id']."</option>\n";

 

i havent a clue what that might do to help, but i know that if i sometimes rewrite my code again, the error disapears.... its really weird

 

You were right that fixed it. Thanks

[The Little Guy]

Try this:

<?php
$g = "SELECT * FROM em ORDER BY id ASC";
$q = mysql_query($g, $link_id) or die(mysql_error());

if (mysql_num_rows($q) > 0){
echo'<select name="d">';
while($r = mysql_fetch_array($q)){
	echo'<option value="'.$r['id'].'">'.$r['id'].'</option>';
}
echo'</select>';
}
?>

 

If that doesn't work, could you explain what it is doing?

[jvrothjr]

PC_Nerd that is true I have also had to re-write code to get the gremilin out.

 

182xx try this

<?php
$g = "SELECT Distinct Id FROM em ORDER BY Id ASC";
$q = mysql_query($g, $link_id) or die(mysql_error());
if (mysql_num_rows($q) > 0) {
echo "<select name='d'>";
while($r = mysql_fetch_assoc($q)) {
	echo "<option value='".$r['Id']."'>".$r['Id']."</option>";
}
             echo "</select>";
}
?>