[Resolved] First Line of array missing

[emmahodd2]

I retrieve info from a database and stick it in an array, then show
it as a html list box select thingy.

Here is my code: -

<select name="example" size="1" onChange="redirect(this.options.selectedIndex)"> 
 <?  	
         $result = DBquery("SELECT * FROM suppliers",$db);  

	$myrow = DBfetch_array($result);  	
            while ($myrow = DBfetch_array($result))
           {  	
               echo '<option>'.$myrow['Name'].'</option>';  

           }
 ?>

For some reason on the page, the first entry in the database doesn't show.

When I go into mySQL and execute the query all 4 rows are returned, but for some reason this page only shows 3, not the 1st one in the database.

Any ideas on what is going on would be appreciated.

Emma 😕

[laserlight]

The problem is that you execute DBfetch_array() once redundantly.

You should then use:

<select name="example" size="1" onChange="redirect(this.options.selectedIndex)">
<?
$result = DBquery("SELECT * FROM suppliers",$db);
while ($myrow = DBfetch_array($result))
{
	echo '<option>' . $myrow['Name'] . '</option>';
}
?>

[philhale]

<select name="example" size="1" onChange="redirect(this.options.selectedIndex)">
<?

$result = DBquery("SELECT * FROM suppliers",$db);

$myrow = DBfetch_array($result);

while ($myrow = DBfetch_array($result))
{

echo '<option>'.$myrow['Name'].'</option>';

}
?>

---

Emma,

Interesting code. As a newby myself, what is happening with the redirect command (this.options.selectedIndex)? What does it do?

Thank you in advance.

Phil.

[laserlight]

that isnt PHP, more likely JS.

There probably is a redirect() function defined somewhere on that page, or from an externally linked script, that redirects the user based on what is selected in the drop down menu.

[philhale]

Thanks, Laser.

I need to learn more about Javascripting commands. I will have to pick up a book sometime.

Cheers.

Phil.

[emmahodd2]

Thank You.

It was the redundant fetch_array. Four eyes are better than two!

The script at the top is Javascript. Its outside the PHP marks <? ?>.

I am trying to do dynamic drop down boxes... so far so good, though it is a headache - as you will see from my other posts!

Emma