query

[Jaens_74]

Hi
I want to query a data base with a search button

the code

$search = $POST['%search%'];
$metoad = $POST['metoad'];
$XX = "No Record Found";
$query = ('SELECT FROM accom LIKE '%$search%' LIMIT 0, 30');
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

with this code it gives me

Query failed: Query was empty

[peppeto]

You are calling %search% two times
one hier $search = $_POST['%search%']; and another hier
'SELECT FROM accom LIKE '%$search%'

make it like $search = $_POST['search];
$query = "SELECT colom FROM accom WHERE colom LIKE '%$search%' LIMIT 0, 30'";