[RESOLVED] Form problems

[MitchEvans]

Has anyone an idea on how to get this code into a "get" form:

$query = "SELECT * FROM soiltype";
$result = mysql_query($query)
or die ("Couldn't execute query");
while($row = mysql_fetch_array($result)) $soiltype[]=$row;

echo '<SELECT name="x">';

foreach ($soiltype as $s)

echo "<OPTION>{$s['soiltype']}</OPTION>\n";
echo '</SELECT>';

$query1 = "SELECT * FROM product";
$result1 = mysql_query($query1)
or die ("Couldn't execute query");
while($row1 = mysql_fetch_array($result1)) $surface[]=$row1;

echo '<SELECT name="y">';

foreach ($surface as $su)

echo "<OPTION>{$su['surface']}</OPTION>";

echo '</SELECT>';

$query2 = "SELECT * FROM product";
$result2 = mysql_query($query2)
or die ("Couldn't execute query");
while($row2 = mysql_fetch_array($result2)) $soillevel[]=$row2;

echo '<SELECT name="z">';

foreach ($soillevel as $so)

echo "<OPTION>{$so['soillevel']}</OPTION>";

echo '</SELECT>';

When I put the form tags around this code the page will not appear on the website.
Any help here please?

[Weedpacket]

Would I be right in guessing that you put it in <?php ...?> as well? I hate having to guess these things..... that's why I'm not trying guess what resulting HTML looks like.

[MitchEvans]

I've sorted it now, I just had to echo the form, whereas I was trying to do it using html, cheers for speedy response though!