first data is missing in while loop

Question

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

Could you post the $mysql_query() statement too?

Andomar
– Andomar

2009-10-30 09:11:25 +00:00
Commented Oct 30, 2009 at 9:11 — Andomar
– Andomar, Commented Oct 30, 2009 at 9:11

Alekc · Accepted Answer · 2009-10-30 09:12:32Z

2

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).

answered Oct 30, 2009 at 9:12

Alekc

4,7906 gold badges34 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Utku Dalmaz Over a year ago

i am getting the selectbox value with this "var aid = $("#artist").val();" maybe this cause that ?

jerjer Over a year ago

You may try $('#artist:selected').val() or $('#artist:selected').text()

Andomar · Accepted Answer · 2009-10-30 09:27:19Z

0

Your ID field is really called label_id. Try:

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

answered Oct 30, 2009 at 9:27

Andomar

239k55 gold badges387 silver badges412 bronze badges

Comments

Sabeen Malik · Accepted Answer · 2009-10-30 09:36:59Z

0

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.

answered Oct 30, 2009 at 9:36

Sabeen Malik

10.9k4 gold badges37 silver badges51 bronze badges

Collectives™ on Stack Overflow

first data is missing in while loop

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related