knaj11

exactly..2 set of lyrics under 1 artist...i want my query to not display repeating artist.

problem with distinct here is that im selecting the id and artist in the db table... see code above...id here is auto increment.

my goal is to query artist name from db which that is starting with a certian first letter sample if L, queries lady gaga, lady antebellum and etc...each artist name contains different songs. lady gaga has bad romance, pokerface, and etc... now my problem is that it my query repeats lady gaga since it has two songs... considering my db table has id, artist, title, content sample db datas: 1 lady gaga bad romance content 2 lady gaga poker face content 3 lady antebellum idk content my query would result lady gaga lady gaga lady antebellum having a hard time to adjust this one to not query repeating artist... $query = "select id, artist from lyrics where artist like 'a%' order by artist ASC"; $result = mysql_query($query) or die ("Error in query: $query . " . mysql_query()); if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_array($result)) { $id = $row['id']; $artist = $row['artist']; ?> <li><b><a href="content.php?id=<?php echo $id; ?> "><?php echo $artist . ' lyrics'; ?></a></b><br> <?php } } else { echo 'No Content'; } thanks in advance for helping...

bout the double post.... i think you got it all wrong... my first post w/ subject "SELECT QUERY HELP" was on how to query something base on its first letter.... my second post w/subject "a href to each result in a query" was on how my result queries to have links on it... just to clear things up mod fenway.. im not sure if my pm for you was sent it was not in my sent items so i did it here instead.

thanks alot both of you it really did work...

i want each result of my query to have a link or be in a <a href =" "> tag.. code is this... $query = "select artist from lyrics where artist like 'a%' order by artist ASC"; $result = mysql_query($query) or die ("Error in query: $query . " . mysql_query()); if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_object($result)) { ?> <?php echo $row->artist; ?><br> <?php } } else { echo 'No Content'; } the result of this code is just this.... Adam Sandler Aqua Avril Lavigne all w/o links... how can i have the resulting queries have links???

got it already..geez im always the one answering my questions..lol

im a novice on this select query thing...well here is the problem.. i want to query artist from the database starting with a certain letter.. sample if i click on <a href="a.php">A</a>..it will show query of all artist starting with letter A...like Aqua, Avril lavigne, etc...

got it already. just need the nl2br function. thanks people.

i have a form which contains a text area. i got a problem on how to format what has been entered in the text area. sample they input paragraphs(well usually) but once they submit the text area it won't save in the correct format. Like how would i let it know that they started a new line and have it automatically enter a <p> tag or whateveer..

i have a text area which is values is stored to mysql after being submitted, i then get the value of the text area from mysql using PHP-post. . now the problem is that the content of my text area are lyrics... it was inputted like this in the text area, and it should look like this after retrieving from mysql.. "Imagine a dirt road full of potholes With a creek bank and some cane poles catchin channel cat I'm a little more country than that" unluckily, it will result to this after retrieving... "Imagine a dirt road full of potholes With a creek bank and some cane poles catchin channel cat I'm a little more country than that" how should i format that??? help please