More mySQL help please

[Guest]

<?php
$search = @$_GET['query'];
$db = mysql_connect('localhost', 'root', '');
      mysql_select_db('site');
$do = "SELECT * FROM sites WHERE file_name LIKE '%\"$search\"%'";
$result = mysql_query($do);


while($files = mysql_fetch_array($result, MYSQL_ASSOC)){
    echo "{$files['file_name']}";
}

echo "<H2>Search Script:</H2><br />";
echo "<FORM ACTION=\"search.php\" METHOD=\"GET\">";
echo "Please Enter Search Query<br />";
    echo "<INPUT NAME=\"query\" TYPE=TEXT>";
    echo "<br />";
    echo "<INPUT TYPE= SUBMIT VALUE=\"Search\">";
echo "</FORM>";
?>

for some reason this isnt displaying any results to my browser any ideas ?

[Guest]

nvm sorry i was missing some basic syntax

<?php
$search = @$_GET['query'];
$db = mysql_connect('localhost', 'root', '');
      mysql_select_db('site');
$do = "SELECT * FROM sites WHERE file_name LIKE '%".$search."%'";
$result = mysql_query($do);
    
echo "<H2>Search Script:</H2>";
echo "<FORM ACTION=\"search.php\" METHOD=\"GET\">";
echo "Please Enter Search Query<br />";
    echo "<INPUT NAME=\"query\" TYPE=TEXT>";
    echo "<br />";
    echo "<INPUT TYPE= SUBMIT VALUE=\"Search\">";
echo "</FORM>";

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
    echo "{$row['file_name']}";

}
?>

[CreativityKills]

nvm sorry i was missing some basic syntax

<?php
$search = @$_GET['query'];
$db = mysql_connect('localhost', 'root', '');
      mysql_select_db('site');
$do = "SELECT * FROM sites WHERE file_name LIKE '%".$search."%'";
$result = mysql_query($do);
    
echo "<H2>Search Script:</H2>";
echo "<FORM ACTION=\"search.php\" METHOD=\"GET\">";
echo "Please Enter Search Query<br />";
    echo "<INPUT NAME=\"query\" TYPE=TEXT>";
    echo "<br />";
    echo "<INPUT TYPE= SUBMIT VALUE=\"Search\">";
echo "</FORM>";

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
    echo "{$row['file_name']}";

}
?>

quit using @ to suppress errors. Its fcuked up.

[Guest]

ok thanks for the advice

[CreativityKills]

Anytime man.