hi,
i have this script, which i want to order by name. but when i say order by name asc at the end i get error:
here is the bit i am changing
$genre_id = $_GET['id'];
$items = ITEMS_PER_PAGE;
if(isset($_GET['page']))
{
$offset = $_GET['page'];
$offset *= $items;
$query = 'select * from artist where genre_id = '.mysql_real_escape_string($genre_id)." limit $offset,$items";
}
else
{
$query = 'select * from artist where genre_id = '.mysql_real_escape_string($genre_id);
}
$allArtists = mysql_query($query);