first data is missing in while loop

Question

Hi

i am trying to get data from db, but in while loop, first data is coming blank, let me show you

<?php
$query = "SELECT * FROM `artists` WHERE label_id = '$id' ORDER BY name";

$result = mysql_query($query);



while ($info = mysql_fetch_array($result)) {

?>

    <option value="<?php echo $info['ID']; ?>"><?php echo $info['name']; ?></option>

   <?php 
        }
 ?>

here first $info['ID'] data of the row is missing, $info['name'] is ok but ID is missing.

where am i wrong you think ?

thx

Answer 1

Check the value keys (if it's not $info['id'] for example).

If it's still not working add after the while this row

print_r($info); die();

In this mode you will see what $info contains (if there is no id, check the query).

Answer 2

Your ID field is really called label_id. Try:

<?php echo $info['label_id']; ?>

Answer 3

Are you sure that the value="x" is missing , the feeling i am getting is that there is something wrong with ur javascript and its not getting the value from the selectbox and based on that you think that the value is missing .. can u view the html source of the output and view in that if the options actually have the value in them .. also posting ur table schema will be helpful.