Why is this code skipping the first record?

[tyler_durden]

I have three records in this table, yet the script below only displays two records, skipping the first item.  I have tried it in other fields also, and it is always skipping the first record?

$result = mysql_query("SELECT * FROM `content_type_ads`");

$row = mysql_fetch_array( $result );

while($row = mysql_fetch_array($result)){
echo $row['nid']. " - ". $row['field_item_id_value'];
echo "<br />";
}

[Alex]

It's skipping the first record because the first record is being grabbed by this line:

 

$row = mysql_fetch_array( $result );

 

and nothing is being done with it. Just remove that line and it should work fine.

[tyler_durden]

Doh!  Thanks, I feel stupid.  Very new to coding.

[tyler_durden]

One last thing, how in the world do I pull just the values in the  field labeled "field_item_id_value" into the array?  That's the only data I need.

[Alex]

Select only the data you need from the database in your query:

 

$result = mysql_query("SELECT field_item_id_value FROM `content_type_ads`");

 

(note: In your code, unless you've changed it since the OP, you're also using the nid column)

[tyler_durden]

I see, I was thinking I had to grab everything to loop. 

 

I was only outputting the nid for testing to compare the records.  I need to see everything step by step to understand.  Thanks!