why the extra line breaks

[hwttdz]

I'm trying to get something that reads out of a database and then has a drop down menu for each piece it gets out of the data base i.e.

car1 color option box
car2 color option box
car3 color option box
car4 color option box
car5 color option box

where color option box is a drop down menu with different choices, with the eventual goal of updating the database with changes made. Right now I can't figure out why the drop boxes appear one line below the leader for the line, I also can't figure out why the extra drop box is being generated at the end.

Here is my code

<?php
$link = @mysql_connect('localhost', 'root', 'password') or 
    die("Could not connect to MySQL");

$db = @mysql_select_db('temp1',$link) or 
    die("Could not select database");

$query = "SELECT * FROM table1"; 
$result = @mysql_query($query,$link) or 
    die("Could not submit query");
$numrows = @mysql_num_rows($result);

for ($i=0; $i<$numrows; $i++) {
    $jones = mysql_fetch_array($result);
    echo ("Location: "."$jones[location]");
    dropmenu();
}

;
function dropmenu()
{
?>
<form action="#" method="post">
<SELECT NAME="state" SIZE="1">
  <OPTION VALUE="1">ACTIVE</OPTION>
  <OPTION VALUE="2">BROKEN</OPTION>
  <OPTION VALUE="3"">PLANNED</OPTION>
</SELECT>
<input type="submit" value="crazy stuff"/>
</form>
<?php
}
dropmenu();

?>

[tunage]

You need to put a new line "\n" after each option -

<SELECT NAME="state" SIZE="1">
<OPTION VALUE="1">ACTIVE</OPTION>\n
<OPTION VALUE="2">BROKEN</OPTION>\n
<OPTION VALUE="3">PLANNED</OPTION>\n
</SELECT>

It looks like your getting a blank menu because your calling the dropmenu() function at the bottom of your code.

[hwttdz]

I'm not getting a blank menu at the bottom I'm getting a menu with the same choices.

What my output looks like is:

Location: location1

[dropmenu] [submit button]

Location: location2

[dropmenu] [submit button]

Location: location3

[dropmenu] [submit button]

[dropmenu] [submit button]

and I'd like it to be more like

Location: location1 [dropmenu] [submit button]
Location: location2 [dropmenu] [submit button]
Location: location3 [dropmenu] [submit button]

[hwttdz]

I got the extra drop menu to go away with the addition of an exit() statement before the end of the main body of code, now I'm just trying to get them to be on the same line.

[tunage]

If you put all the output within the <form> like this does it work?

<?php
for ($i=0; $i<$numrows; $i++) 
{
    $jones = mysql_fetch_array($result);

echo "<BR><form action='test.php' method='post'>";
echo "Location: " . $jones[location];

dropmenu();

echo "<input type='submit' value='crazy stuff'></form>";
}


function dropmenu()
{
?>
<SELECT NAME="state" SIZE="1">
  <OPTION VALUE="1">ACTIVE</OPTION>\n
  <OPTION VALUE="2">BROKEN</OPTION>\n
  <OPTION VALUE="3">PLANNED</OPTION>\n
</SELECT>
<?php
}

[hwttdz]

Actually that gave me no output at all. I'll take a look at it later because it looks like it's possibly a much more elegant way to do this. What I have right now is actually getting pretty close, at least for this tiny piece of the project. It looks like

<?php
$link = @mysql_connect('localhost', 'root', 'password') or 
    die("Could not connect to MySQL");//connects

$db = @mysql_select_db('temp1',$link) or 
    die("Could not select database");//selects database

$query = "SELECT * FROM table1"; //selects all of the entries from the table
$result = @mysql_query($query,$link) or 
    die("Could not submit query");
$numrows = @mysql_num_rows($result);

for ($i=0; $i<$numrows; $i++) 
 {
    $jones = mysql_fetch_array($result);
    print ("Location: "."$jones[location]");
    echo("$i");
    dropmenu();
    echo('<br>');

 }
exit("bye");
?>

<?php
function dropmenu()
{
?>

<SELECT NAME="state" SIZE="1">
  <OPTION VALUE="1">ACTIVE</OPTION>
  <OPTION VALUE="2">BROKEN</OPTION>
  <OPTION VALUE="3"">PLANNED</OPTION>
</SELECT>

<input type="submit" value="crazy stuff"/>
<?php
}
dropmenu();
?>

I'm not really sure how the print line shows only one of the entries from the table.

[tunage]

<?php
$link = @mysql_connect('localhost', 'root', 'password') or 
    die("Could not connect to MySQL");//connects

$db = @mysql_select_db('temp1',$link) or 
    die("Could not select database");//selects database

$query = "SELECT * FROM table1"; //selects all of the entries from the table
$result = @mysql_query($query,$link) or 
    die("Could not submit query");
$numrows = @mysql_num_rows($result);


for ($i=0; $i<$numrows; $i++)  

{ 
    $jones = mysql_fetch_array($result); 

echo "<BR><form action='test.php' method='post'>"; 
echo "Location: " . $jones[location]; 

dropmenu(); 

echo "<input type='submit' value='crazy stuff'></form>"; 
} 


function dropmenu() 
{ 
?> 
<SELECT NAME="state" SIZE="1"> 
  <OPTION VALUE="1">ACTIVE</OPTION>\n 
  <OPTION VALUE="2">BROKEN</OPTION>\n 
  <OPTION VALUE="3">PLANNED</OPTION>\n 
</SELECT> 
<?php 
}