OK, this is not even a project. But I would be glad someone could just help me with this. My questions is:
How do i rewrite this SQL-query to also include the field song_id which is next to the songtitle-field in the table songs.
$result = mysql_query("SELECT DISTINCT songtitle FROM songs WHERE view_for_public='y' ");
But that clause doesn't give me the song_id field which I need. So..the same result as the above wuery but also with the song_id field included.