Lidt svær
hej ..jeg vil gerne hente fra en tabel i databasen som hedder (velge(enum)>> new) ??
jeg ved måske at fejlen er i select linien?
<?
#######################################
if (empty($_REQUEST["id"]))
{
$order = array("date", "num", "name");
if (in_array($_REQUEST["order"], $order))
{
$order = $_REQUEST["order"];
}
else
{
$order = "id";
}
if (!empty($_REQUEST["l"])) $where = " AND album.al_name like '".substr($_REQUEST["l"], 0, 1)."%'";
$SQL = "select album.*,artist.* from album,artist where artist.ar_id=album.velge".$where." order by album.al_".$order." desc";
$SQL =("select velge from album where velge='" . $_POST['new'] . "' order by desc") or die (mysql_error());
$page = mysql_num_rows(mysql_query($SQL));
$query = mysql_query($SQL." limit $limit,$pages") or die(mysql_error());
#######################################
browse_by();
if ($page<=0) {
nothing_found();
} else {
create_pages($page);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><font size=1><font color="#FF6900">
<?=$date[0];?>
</font> <font color="#666666">
<?=$date[1];?>
</font><br>
<a href='<?=$PHP_SELF?>?p=album&id=<?=$row["al_id"]?>'><img src="<?=$img?>" width="100" height="100" hspace="4" vspace="4" border="1" style="border-color:#000000"><br>
<?=ucwords(strtolower($row["al_name"]))?>
</a><br>
<a href='<?=$PHP_SELF?>?p=artist&id=<?=$row["ar_id"]?>'><font color='#909090'>
<?=ucwords($row["ar_name"])?>
</font></a></font></td>
</tr>
</table>
<? } ?>
