code won't work - please help

[crzyman]

I want a user to be able to search by letter. Can't get this code to work. I have a page search.php with <a href=search2.php?id='A>A</a>
then a page called search2.php with this code:
<?

mysql_connect("mysql","name","password");

mysql_select_db("ims_search");

$name=$_GET['id'];

"Your search found "; $query = mysql_query("SELECT * FROM artist WHERE artist_name LIKE

'$name%'"); $rows = mysql_num_rows($query); echo $rows; echo " result(s)";echo "<br>";

$result = mysql_query("SELECT * FROM artist WHERE artist_name LIKE '$name%'");

while($r=mysql_fetch_array($result))
{

$artist_name=$r["artist_name"];

$clean = str_replace(" ","",$artist_name);

   echo "<a href='/$clean'>$artist_name</a>";

echo "<br>";
}
?>

When I run search.php I get "0 results", when I should get all the artist who's name starts with the letter 'A'. Any help would be greatly appreciated.

[halojoy]

<!-- this should be correct HTML link
Or in php: echo "<a href='search2.php?id=A'>A</a>"; -->
<a href='search2.php?id=A'>A</a> 

<?php
//////////////////////////////////////////////////////////////////////////
// search2.php

mysql_connect("mysql","name","password"); 
mysql_select_db("ims_search"); 

$name=$_GET['id']; // $name will be 'A', in this case

// Search for names where A is first letter, $name has a lenght of 1
// Regarding mySQL: I am from Barcelona!  (see my signature)
$query = mysql_query("SELECT * FROM artist WHERE artist_name LIKE 
'$name%'");
$rows = mysql_num_rows($query);

echo "Your search found ";
echo $rows;
echo " result(s)";
echo "<br>";

?>

[crzyman]

That worked great. I so appreciate it. Again thanks.

[halojoy]

thanks crzyman
🙂
Gives a rewarding feeling, when you can help some fellow man.
Isnt that so?
Ask small children ..... they know.