Select Efter alfabet
Hej eksperter.Hvordan skal jeg skrive denne kode om så jeg kun selecter alt som starter med bogstavet "a"
<?
$database = mysql_connect("localhost","user","passwd");
mysql_select_db("db");
$foresp2 = mysql_query("SELECT * FROM tabel ORDER BY `overskrift` ASC LIMIT 0, 100");
while($data = mysql_fetch_array($foresp2)){
$id2 = $data["id"];
$overskrift2 = $data["overskrift"];
$intro2 = $data["intro"];
print"
<div align='center'>
<center>
<table border='1' width='90%' bordercolor='#000000' cellspacing='0' cellpadding='0'>
<tr>
<td width='100%' bgcolor='#CAEEFF'><b><font face='Verdana' size='1'>-:$overskrift2</font></b></td>
</tr>
<tr>
<td width='100%'>
<p align='center'><i><font color='#000000' size='1' face='Verdana'>$intro2</font></i></td>
</tr>
<tr>
<td width='100%' bgcolor='#CAEEFF'>
<p align='right'><font size='1' face='Verdana'><b><a href='frontmovie1.php?id=$id2' target='_top'>Læs
Mere</a></b></font></td>
</tr>
</table>
</center>
</div>
<table width='100%' cellspacing cellpadding>
<tr>
<td width='100%'> </td>
</tr>
</table>
<table width='100%' cellspacing cellpadding>
<td>
"
?>
<?
}
?>
Den skal kun hente det der starter med "a"
