alphabet search

[allan16]

Hello!!!

I have the following page:

http://musicaenvivocr.com/artistas2.php

Its got the alphabet showing due to an php code that I have.

I have an MySQL table with a table called artista and a column called artista_name. I need to have that when someone click on any of those letters to display all the artist names starting with the letter selected.

Here is the code:

<?php

	    $con = mysql_connect("xxxxxx","xxxxxxxx","xxxxxxxxx");
        if (!$con)
        {
        die('Could not connect: ' . mysql_error());
        }
		mysql_select_db("xxxxxxxx", $con);

		for ($i="A"; $i != "AA"; $i++) echo "<a href=\"artistas2.php?field=$i\"> $i&nbsp; </a>";
        $i=$_REQUEST['field'];

		$query = "SELECT * FROM artista where field LIKE '$i%' ";  

	   ?>

Thanks

[dagon]

continuing your code:

$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
    echo $row['firstname'];
}

of course i don't know what you want to echo out, your db field names or the appropriate html, but hat should get you started