More mySQL help please

**NoFx** · 02-10-10, 13:10

PHP Code:

 <?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 ?

**NoFx** · 02-10-10, 14:12

nvm sorry i was missing some basic syntax

PHP Code:

 <?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** · 02-10-10, 16:12

Originally Posted by NoFx [Only registered and activated users can see links. Click Here To Register...]

nvm sorry i was missing some basic syntax

PHP Code:

 <?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.