Using a Form to Search Site. Why Doesn't My Form Work?

OK, guys. I finally done it! YES!

Well . . . Actually, someone else from Webmasterworld done it for me!

Whatever the case, here's the code:

<?php

$search = $_POST["search"];

$con = mysql_connect("localhost","root","") or die('cant connect: '.mysql_error());

mysql_select_db("ctyi", $con);

$sql = "SELECT advertiser_name from Advertiser_Table WHERE advertiser_name LIKE '%$search%'";

$result = mysql_query($sql) or die('cant select: '.mysql_error());

if(mysql_num_rows($result)) 

{
while($row = mysql_fetch_assoc($result) )
{

echo $row['advertiser_name'] . "<br />";
}
} // EndIf show match(es)

else 
{
echo "Sorry! No matches found";
} // EndElse no matches

?> 

PHP:

 

hi. yes i am busy, but i have a lot of work on. if you want me to complete work it will cost $110USD, let me know. asap. Jay

 

Huh?!

Who are you responding to, dude? Was that meant to be a private message to someone?