Explode
Har følgende:<?
$streng=":SAS:Lufthansa:Maersk:LOT:Sterling:Air Canada:Emirates:Air France:";
$air=explode(":", $streng);
sort($air);
echo "<form method=\"post\">
<select name=\"flyselskab\">
<option>Vælg flyselskab</option>
<option value=$air[1]>$air[1]</option>
<option value=$air[2]>$air[2]</option>
<option value=$air[3]>$air[3]</option>
<option value=$air[4]>$air[4]</option>
<option value=$air[5]>$air[5]</option>
<option value=$air[6]>$air[6]</option>
<option value=$air[7]>$air[7]</option>
<option value=$air[8]>$air[8]</option>
</select>
<input type=submit Value=Vis Class=log name=vis>
</form>
</select>";
if($vis){
$con=MYSQL_CONNECT("xxx","xxx","xxx") or die ('Fandt ikke DB');
mysql_select_db("xxx", $con) or die ("Fandt ikke database");
$pick = mysql_query("SELECT * FROM Billeder WHERE Airline='$_POST[flyselskab]' ORDER BY id DESC") or die ("Mysql fejl, bliver nok rettet hurtigst muligt");
while($ALL=mysql_fetch_row($pick)){
echo "<table width=630> <td bgcolor=#969696 border=1 align=left width=500 Class=Bordet> <a href=vispic.php?id=$ALL[0]><img src=images/$ALL[1] width=200 height=200 align=left border=1 border-color=#FFFFFF></a>";
echo "<p><b>Info</b><br>
<b>Type/model:</b> $ALL[3] <br>
<b>Airport:</b> $ALL[2] <br>
<b>Airline:</b> $ALL[4] <br
<b>Photo by:</b><a href=mailto:$ALL[5] class=logina> $ALL[6] </a></font></b><br>
</p>
</td></table>";
}
}
?>
Men den vil bare ikke hente når Flyselskabet er i 2 ord :-/
