[SOLVED] <select> problems!!!

[messer]

Please , someone to help me ...

I have an <select> and this

$query = mysql_query("SELECT * FROM articles ORDER BY ".addentities('ArtID')."");

in my database i have 4 articles but in select menu only 3 , why so???

[soak]

Can you please post the code snippet that renders the select box?

 

 

[messer]

  function meniu_select() 
{ 

  include('dbinfo.inc.php'); 
  
$Link = mysql_connect ("localhost", $username, $password) or die ('error');
mysql_select_db($database) or die( "Unable to select database");

  $query = mysql_query("SELECT * FROM artikels ORDER BY ".addentities('ArtID').""); 
  $row = mysql_fetch_array($query);
    $select = '<select name="artikels[]">'; 

      while ($row = mysql_fetch_array($query)) 
    { 
      $select.= '<option value="'.addentities($row['ArtID']).'">'; 
      $select.= ''.addentities($row['ArtNummer']).' -:- '.addentities($row['ArtDescription']).'';   
      $select.= '</option>'; 
    } 

  $select.= '</select>'; 
  
  return $select; 

[messer]

In Database : ArtID int(7)  No  auto_increment

[FaT3oYCG]

  function meniu_select() 
{ 

  include('dbinfo.inc.php'); 
  
$Link = mysql_connect ("localhost", $username, $password) or die ('error');
mysql_select_db($database) or die( "Unable to select database");

  $query = mysql_query("SELECT * FROM artikels ORDER BY ".addentities('ArtID').""); 
  $row = mysql_fetch_array($query); // <-- REMOVE THIS LINE
    $select = '<select name="artikels[]">'; 

      while ($row = mysql_fetch_array($query)) 
    { 
      $select.= '<option value="'.addentities($row['ArtID']).'">'; 
      $select.= ''.addentities($row['ArtNummer']).' -:- '.addentities($row['ArtDescription']).'';   
      $select.= '</option>'; 
    } 

  $select.= '</select>'; 
  
  return $select; 

 

remove the line i pointed out

[messer]

Thanks a lot... i'll learn it for future  it works.